Profiling Report for Loan dataset

Dataset statistics

Number of variables	111
Number of observations	39717
Missing cells	2263364
Missing cells (%)	51.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	33.6 MiB
Average record size in memory	888.0 B

Variable types

Numeric	25
Categorical	19
Text	11
Boolean	2
Unsupported	54

Alerts

`pymnt_plan` has constant value ""	Constant
`initial_list_status` has constant value ""	Constant
`collections_12_mths_ex_med` has constant value ""	Constant
`policy_code` has constant value ""	Constant
`application_type` has constant value ""	Constant
`acc_now_delinq` has constant value ""	Constant
`chargeoff_within_12_mths` has constant value ""	Constant
`delinq_amnt` has constant value ""	Constant
`tax_liens` has constant value ""	Constant
`id` is highly overall correlated with `member_id` and 1 other fields	High correlation
`member_id` is highly overall correlated with `id` and 1 other fields	High correlation
`loan_amnt` is highly overall correlated with `funded_amnt` and 6 other fields	High correlation
`funded_amnt` is highly overall correlated with `loan_amnt` and 6 other fields	High correlation
`funded_amnt_inv` is highly overall correlated with `loan_amnt` and 6 other fields	High correlation
`installment` is highly overall correlated with `loan_amnt` and 6 other fields	High correlation
`delinq_2yrs` is highly overall correlated with `mths_since_last_delinq`	High correlation
`mths_since_last_delinq` is highly overall correlated with `delinq_2yrs` and 1 other fields	High correlation
`mths_since_last_record` is highly overall correlated with `id` and 5 other fields	High correlation
`open_acc` is highly overall correlated with `total_acc`	High correlation
`total_acc` is highly overall correlated with `open_acc`	High correlation
`out_prncp` is highly overall correlated with `out_prncp_inv` and 1 other fields	High correlation
`out_prncp_inv` is highly overall correlated with `out_prncp` and 1 other fields	High correlation
`total_pymnt` is highly overall correlated with `loan_amnt` and 6 other fields	High correlation
`total_pymnt_inv` is highly overall correlated with `loan_amnt` and 6 other fields	High correlation
`total_rec_prncp` is highly overall correlated with `loan_amnt` and 7 other fields	High correlation
`total_rec_int` is highly overall correlated with `loan_amnt` and 7 other fields	High correlation
`recoveries` is highly overall correlated with `collection_recovery_fee` and 1 other fields	High correlation
`collection_recovery_fee` is highly overall correlated with `recoveries` and 1 other fields	High correlation
`last_pymnt_amnt` is highly overall correlated with `total_rec_prncp` and 1 other fields	High correlation
`term` is highly overall correlated with `total_rec_int` and 1 other fields	High correlation
`grade` is highly overall correlated with `sub_grade`	High correlation
`sub_grade` is highly overall correlated with `grade`	High correlation
`loan_status` is highly overall correlated with `out_prncp` and 2 other fields	High correlation
`pub_rec` is highly overall correlated with `mths_since_last_record` and 1 other fields	High correlation
`next_pymnt_d` is highly overall correlated with `mths_since_last_record` and 5 other fields	High correlation
`pub_rec_bankruptcies` is highly overall correlated with `mths_since_last_record` and 1 other fields	High correlation
`loan_status` is highly imbalanced (51.4%)	Imbalance
`pub_rec` is highly imbalanced (86.6%)	Imbalance
`next_pymnt_d` is highly imbalanced (89.9%)	Imbalance
`pub_rec_bankruptcies` is highly imbalanced (83.7%)	Imbalance
`emp_title` has 2459 (6.2%) missing values	Missing
`emp_length` has 1075 (2.7%) missing values	Missing
`desc` has 12940 (32.6%) missing values	Missing
`mths_since_last_delinq` has 25682 (64.7%) missing values	Missing
`mths_since_last_record` has 36931 (93.0%) missing values	Missing
`next_pymnt_d` has 38577 (97.1%) missing values	Missing
`mths_since_last_major_derog` has 39717 (100.0%) missing values	Missing
`annual_inc_joint` has 39717 (100.0%) missing values	Missing
`dti_joint` has 39717 (100.0%) missing values	Missing
`verification_status_joint` has 39717 (100.0%) missing values	Missing
`tot_coll_amt` has 39717 (100.0%) missing values	Missing
`tot_cur_bal` has 39717 (100.0%) missing values	Missing
`open_acc_6m` has 39717 (100.0%) missing values	Missing
`open_il_6m` has 39717 (100.0%) missing values	Missing
`open_il_12m` has 39717 (100.0%) missing values	Missing
`open_il_24m` has 39717 (100.0%) missing values	Missing
`mths_since_rcnt_il` has 39717 (100.0%) missing values	Missing
`total_bal_il` has 39717 (100.0%) missing values	Missing
`il_util` has 39717 (100.0%) missing values	Missing
`open_rv_12m` has 39717 (100.0%) missing values	Missing
`open_rv_24m` has 39717 (100.0%) missing values	Missing
`max_bal_bc` has 39717 (100.0%) missing values	Missing
`all_util` has 39717 (100.0%) missing values	Missing
`total_rev_hi_lim` has 39717 (100.0%) missing values	Missing
`inq_fi` has 39717 (100.0%) missing values	Missing
`total_cu_tl` has 39717 (100.0%) missing values	Missing
`inq_last_12m` has 39717 (100.0%) missing values	Missing
`acc_open_past_24mths` has 39717 (100.0%) missing values	Missing
`avg_cur_bal` has 39717 (100.0%) missing values	Missing
`bc_open_to_buy` has 39717 (100.0%) missing values	Missing
`bc_util` has 39717 (100.0%) missing values	Missing
`mo_sin_old_il_acct` has 39717 (100.0%) missing values	Missing
`mo_sin_old_rev_tl_op` has 39717 (100.0%) missing values	Missing
`mo_sin_rcnt_rev_tl_op` has 39717 (100.0%) missing values	Missing
`mo_sin_rcnt_tl` has 39717 (100.0%) missing values	Missing
`mort_acc` has 39717 (100.0%) missing values	Missing
`mths_since_recent_bc` has 39717 (100.0%) missing values	Missing
`mths_since_recent_bc_dlq` has 39717 (100.0%) missing values	Missing
`mths_since_recent_inq` has 39717 (100.0%) missing values	Missing
`mths_since_recent_revol_delinq` has 39717 (100.0%) missing values	Missing
`num_accts_ever_120_pd` has 39717 (100.0%) missing values	Missing
`num_actv_bc_tl` has 39717 (100.0%) missing values	Missing
`num_actv_rev_tl` has 39717 (100.0%) missing values	Missing
`num_bc_sats` has 39717 (100.0%) missing values	Missing
`num_bc_tl` has 39717 (100.0%) missing values	Missing
`num_il_tl` has 39717 (100.0%) missing values	Missing
`num_op_rev_tl` has 39717 (100.0%) missing values	Missing
`num_rev_accts` has 39717 (100.0%) missing values	Missing
`num_rev_tl_bal_gt_0` has 39717 (100.0%) missing values	Missing
`num_sats` has 39717 (100.0%) missing values	Missing
`num_tl_120dpd_2m` has 39717 (100.0%) missing values	Missing
`num_tl_30dpd` has 39717 (100.0%) missing values	Missing
`num_tl_90g_dpd_24m` has 39717 (100.0%) missing values	Missing
`num_tl_op_past_12m` has 39717 (100.0%) missing values	Missing
`pct_tl_nvr_dlq` has 39717 (100.0%) missing values	Missing
`percent_bc_gt_75` has 39717 (100.0%) missing values	Missing
`pub_rec_bankruptcies` has 697 (1.8%) missing values	Missing
`tot_hi_cred_lim` has 39717 (100.0%) missing values	Missing
`total_bal_ex_mort` has 39717 (100.0%) missing values	Missing
`total_bc_limit` has 39717 (100.0%) missing values	Missing
`total_il_high_credit_limit` has 39717 (100.0%) missing values	Missing
`annual_inc` is highly skewed (γ1 = 30.9491846)	Skewed
`collection_recovery_fee` is highly skewed (γ1 = 25.02941842)	Skewed
`id` has unique values	Unique
`member_id` has unique values	Unique
`url` has unique values	Unique
`mths_since_last_major_derog` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`annual_inc_joint` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`dti_joint` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`verification_status_joint` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`tot_coll_amt` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`tot_cur_bal` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`open_acc_6m` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`open_il_6m` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`open_il_12m` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`open_il_24m` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`mths_since_rcnt_il` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`total_bal_il` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`il_util` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`open_rv_12m` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`open_rv_24m` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`max_bal_bc` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`all_util` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`total_rev_hi_lim` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`inq_fi` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`total_cu_tl` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`inq_last_12m` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`acc_open_past_24mths` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`avg_cur_bal` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`bc_open_to_buy` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`bc_util` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`mo_sin_old_il_acct` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`mo_sin_old_rev_tl_op` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`mo_sin_rcnt_rev_tl_op` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`mo_sin_rcnt_tl` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`mort_acc` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`mths_since_recent_bc` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`mths_since_recent_bc_dlq` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`mths_since_recent_inq` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`mths_since_recent_revol_delinq` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`num_accts_ever_120_pd` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`num_actv_bc_tl` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`num_actv_rev_tl` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`num_bc_sats` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`num_bc_tl` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`num_il_tl` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`num_op_rev_tl` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`num_rev_accts` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`num_rev_tl_bal_gt_0` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`num_sats` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`num_tl_120dpd_2m` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`num_tl_30dpd` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`num_tl_90g_dpd_24m` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`num_tl_op_past_12m` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`pct_tl_nvr_dlq` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`percent_bc_gt_75` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`tot_hi_cred_lim` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`total_bal_ex_mort` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`total_bc_limit` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`total_il_high_credit_limit` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`delinq_2yrs` has 35405 (89.1%) zeros	Zeros
`inq_last_6mths` has 19300 (48.6%) zeros	Zeros
`mths_since_last_delinq` has 443 (1.1%) zeros	Zeros
`mths_since_last_record` has 670 (1.7%) zeros	Zeros
`revol_bal` has 994 (2.5%) zeros	Zeros
`out_prncp` has 38577 (97.1%) zeros	Zeros
`out_prncp_inv` has 38577 (97.1%) zeros	Zeros
`total_rec_late_fee` has 37671 (94.8%) zeros	Zeros
`recoveries` has 35499 (89.4%) zeros	Zeros
`collection_recovery_fee` has 35935 (90.5%) zeros	Zeros

Reproduction

Analysis started	2023-09-30 13:42:15.083672
Analysis finished	2023-09-30 13:42:55.506883
Duration	40.42 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

id
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	39717
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	683131.91

Minimum	54734
Maximum	1077501
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	310.4 KiB

Quantile statistics

Minimum	54734
5-th percentile	372418.4
Q1	516221
median	665665
Q3	837755
95-th percentile	1039966.2
Maximum	1077501
Range	1022767
Interquartile range (IQR)	321534

Descriptive statistics

Standard deviation	210694.13
Coefficient of variation (CV)	0.30842379
Kurtosis	-0.7298894
Mean	683131.91
Median Absolute Deviation (MAD)	160026
Skewness	0.078807632
Sum	2.713195 × 10¹⁰
Variance	4.4392018 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1077501	1	< 0.1%
568534	1	< 0.1%
568659	1	< 0.1%
567165	1	< 0.1%
568531	1	< 0.1%
568623	1	< 0.1%
568605	1	< 0.1%
556021	1	< 0.1%
568568	1	< 0.1%
568525	1	< 0.1%
Other values (39707)	39707	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
54734	1	< 0.1%
55742	1	< 0.1%
57245	1	< 0.1%
57416	1	< 0.1%
58915	1	< 0.1%
59006	1	< 0.1%
61390	1	< 0.1%
61419	1	< 0.1%
62102	1	< 0.1%
65426	1	< 0.1%

Value	Count	Frequency (%)
1077501	1	< 0.1%
1077430	1	< 0.1%
1077175	1	< 0.1%
1076863	1	< 0.1%
1075358	1	< 0.1%
1075269	1	< 0.1%
1072053	1	< 0.1%
1071795	1	< 0.1%
1071570	1	< 0.1%
1070078	1	< 0.1%

member_id
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	39717
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	850463.56

Minimum	70699
Maximum	1314167
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	310.4 KiB

Quantile statistics

Minimum	70699
5-th percentile	388192.4
Q1	666780
median	850812
Q3	1047339
95-th percentile	1269461.8
Maximum	1314167
Range	1243468
Interquartile range (IQR)	380559

Descriptive statistics

Standard deviation	265678.31
Coefficient of variation (CV)	0.31239235
Kurtosis	-0.56296801
Mean	850463.56
Median Absolute Deviation (MAD)	190427
Skewness	-0.21241637
Sum	3.3777861 × 10¹⁰
Variance	7.0584963 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1296599	1	< 0.1%
731393	1	< 0.1%
731544	1	< 0.1%
729629	1	< 0.1%
731390	1	< 0.1%
731500	1	< 0.1%
731481	1	< 0.1%
716015	1	< 0.1%
731438	1	< 0.1%
731382	1	< 0.1%
Other values (39707)	39707	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
70699	1	< 0.1%
73673	1	< 0.1%
74724	1	< 0.1%
76583	1	< 0.1%
80353	1	< 0.1%
80364	1	< 0.1%
84914	1	< 0.1%
85483	1	< 0.1%
86999	1	< 0.1%
89243	1	< 0.1%

Value	Count	Frequency (%)
1314167	1	< 0.1%
1313524	1	< 0.1%
1311748	1	< 0.1%
1311441	1	< 0.1%
1306957	1	< 0.1%
1306721	1	< 0.1%
1305201	1	< 0.1%
1305008	1	< 0.1%
1304956	1	< 0.1%
1304884	1	< 0.1%

loan_amnt
Real number (ℝ)

HIGH CORRELATION

Distinct	885
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11219.444

Minimum	500
Maximum	35000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	310.4 KiB

Quantile statistics

Minimum	500
5-th percentile	2400
Q1	5500
median	10000
Q3	15000
95-th percentile	25000
Maximum	35000
Range	34500
Interquartile range (IQR)	9500

Descriptive statistics

Standard deviation	7456.6707
Coefficient of variation (CV)	0.66462035
Kurtosis	0.76866855
Mean	11219.444
Median Absolute Deviation (MAD)	5000
Skewness	1.0593173
Sum	4.4560265 × 10⁸
Variance	55601938
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10000	2833	7.1%
12000	2334	5.9%
5000	2051	5.2%
6000	1908	4.8%
15000	1895	4.8%
20000	1626	4.1%
8000	1586	4.0%
25000	1390	3.5%
4000	1130	2.8%
3000	1030	2.6%
Other values (875)	21934	55.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
500	5	< 0.1%
700	1	< 0.1%
725	1	< 0.1%
750	1	< 0.1%
800	1	< 0.1%
900	2	< 0.1%
950	1	< 0.1%
1000	301	0.8%
1050	4	< 0.1%
1075	1	< 0.1%

Value	Count	Frequency (%)
35000	679	1.7%
34800	2	< 0.1%
34675	1	< 0.1%
34525	1	< 0.1%
34475	5	< 0.1%
34200	1	< 0.1%
34000	15	< 0.1%
33950	9	< 0.1%
33600	6	< 0.1%
33500	2	< 0.1%

funded_amnt
Real number (ℝ)

HIGH CORRELATION

Distinct	1041
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10947.713

Minimum	500
Maximum	35000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	310.4 KiB

Quantile statistics

Minimum	500
5-th percentile	2400
Q1	5400
median	9600
Q3	15000
95-th percentile	25000
Maximum	35000
Range	34500
Interquartile range (IQR)	9600

Descriptive statistics

Standard deviation	7187.2387
Coefficient of variation (CV)	0.65650593
Kurtosis	0.93755199
Mean	10947.713
Median Absolute Deviation (MAD)	4600
Skewness	1.0817102
Sum	4.3481032 × 10⁸
Variance	51656400
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10000	2741	6.9%
12000	2244	5.6%
5000	2040	5.1%
6000	1898	4.8%
15000	1784	4.5%
8000	1573	4.0%
20000	1456	3.7%
25000	1133	2.9%
4000	1127	2.8%
3000	1022	2.6%
Other values (1031)	22699	57.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
500	5	< 0.1%
700	1	< 0.1%
725	1	< 0.1%
750	1	< 0.1%
800	1	< 0.1%
900	2	< 0.1%
950	1	< 0.1%
1000	302	0.8%
1050	5	< 0.1%
1075	1	< 0.1%

Value	Count	Frequency (%)
35000	554	1.4%
34800	1	< 0.1%
34675	2	< 0.1%
34525	1	< 0.1%
34475	4	< 0.1%
34250	1	< 0.1%
34000	14	< 0.1%
33950	6	< 0.1%
33600	6	< 0.1%
33500	1	< 0.1%

funded_amnt_inv
Real number (ℝ)

HIGH CORRELATION

Distinct	8205
Distinct (%)	20.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10397.449

Minimum	0
Maximum	35000
Zeros	129
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	310.4 KiB

Quantile statistics

Minimum	0
5-th percentile	1873.658
Q1	5000
median	8975
Q3	14400
95-th percentile	24736.572
Maximum	35000
Range	35000
Interquartile range (IQR)	9400

Descriptive statistics

Standard deviation	7128.4504
Coefficient of variation (CV)	0.6855961
Kurtosis	1.0625444
Mean	10397.449
Median Absolute Deviation (MAD)	4200
Skewness	1.1062129
Sum	4.1295548 × 10⁸
Variance	50814806
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5000	1309	3.3%
10000	1275	3.2%
6000	1200	3.0%
12000	1069	2.7%
8000	900	2.3%
4000	812	2.0%
3000	803	2.0%
15000	657	1.7%
7000	600	1.5%
2000	452	1.1%
Other values (8195)	30640	77.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	129	0.3%
0.000121098	1	< 0.1%
0.000531133	1	< 0.1%
0.000654607	1	< 0.1%
0.001867696	1	< 0.1%
0.001963093	1	< 0.1%
0.001966974	1	< 0.1%
0.002251738	1	< 0.1%
0.002283598	1	< 0.1%
0.002373058	1	< 0.1%

Value	Count	Frequency (%)
35000	135	0.3%
34997.35245	1	< 0.1%
34993.65539	1	< 0.1%
34993.32571	1	< 0.1%
34993.26306	1	< 0.1%
34993.19696	1	< 0.1%
34990.4308	1	< 0.1%
34987.98452	1	< 0.1%
34987.27101	1	< 0.1%
34977.34674	1	< 0.1%

term
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

36 months	29096
60 months	10621

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	397170
Distinct characters	10
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	36 months
2nd row	60 months
3rd row	36 months
4th row	36 months
5th row	60 months

Common Values

Value	Count	Frequency (%)
36 months	29096	73.3%
60 months	10621	26.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
months	39717	50.0%
36	29096	36.6%
60	10621	13.4%

Most occurring characters

Value	Count	Frequency (%)
	79434	20.0%
6	39717	10.0%
m	39717	10.0%
o	39717	10.0%
n	39717	10.0%
t	39717	10.0%
h	39717	10.0%
s	39717	10.0%
3	29096	7.3%
0	10621	2.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	238302	60.0%
Space Separator	79434	20.0%
Decimal Number	79434	20.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
m	39717	16.7%
o	39717	16.7%
n	39717	16.7%
t	39717	16.7%
h	39717	16.7%
s	39717	16.7%

Decimal Number

Value	Count	Frequency (%)
6	39717	50.0%
3	29096	36.6%
0	10621	13.4%

Space Separator

Value	Count	Frequency (%)
	79434	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	238302	60.0%
Common	158868	40.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
m	39717	16.7%
o	39717	16.7%
n	39717	16.7%
t	39717	16.7%
h	39717	16.7%
s	39717	16.7%

Common

Value	Count	Frequency (%)
	79434	50.0%
6	39717	25.0%
3	29096	18.3%
0	10621	6.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	397170	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	79434	20.0%
6	39717	10.0%
m	39717	10.0%
o	39717	10.0%
n	39717	10.0%
t	39717	10.0%
h	39717	10.0%
s	39717	10.0%
3	29096	7.3%
0	10621	2.7%

int_rate
Text

Distinct	371
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

Length

Max length	6
Median length	6
Mean length	5.6942871
Min length	5

Characters and Unicode

Total characters	226160
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	17 ?
Unique (%)	< 0.1%

Sample

1st row	10.65%
2nd row	15.27%
3rd row	15.96%
4th row	13.49%
5th row	12.69%

Value	Count	Frequency (%)
10.99	956	2.4%
13.49	826	2.1%
11.49	825	2.1%
7.51	787	2.0%
7.88	725	1.8%
7.49	656	1.7%
11.71	607	1.5%
9.99	603	1.5%
7.90	582	1.5%
5.42	573	1.4%
Other values (361)	32577	82.0%

Most occurring characters

Value	Count	Frequency (%)
.	39717	17.6%
%	39717	17.6%
1	38195	16.9%
9	21893	9.7%
2	12734	5.6%
7	12132	5.4%
6	12033	5.3%
4	11091	4.9%
5	9947	4.4%
3	9929	4.4%
Other values (2)	18772	8.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	146726	64.9%
Other Punctuation	79434	35.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	38195	26.0%
9	21893	14.9%
2	12734	8.7%
7	12132	8.3%
6	12033	8.2%
4	11091	7.6%
5	9947	6.8%
3	9929	6.8%
8	9527	6.5%
0	9245	6.3%

Other Punctuation

Value	Count	Frequency (%)
.	39717	50.0%
%	39717	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	226160	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
.	39717	17.6%
%	39717	17.6%
1	38195	16.9%
9	21893	9.7%
2	12734	5.6%
7	12132	5.4%
6	12033	5.3%
4	11091	4.9%
5	9947	4.4%
3	9929	4.4%
Other values (2)	18772	8.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	226160	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	39717	17.6%
%	39717	17.6%
1	38195	16.9%
9	21893	9.7%
2	12734	5.6%
7	12132	5.4%
6	12033	5.3%
4	11091	4.9%
5	9947	4.4%
3	9929	4.4%
Other values (2)	18772	8.3%

installment
Real number (ℝ)

HIGH CORRELATION

Distinct	15383
Distinct (%)	38.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	324.56192

Minimum	15.69
Maximum	1305.19
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	310.4 KiB

Quantile statistics

Minimum	15.69
5-th percentile	71.246
Q1	167.02
median	280.22
Q3	430.78
95-th percentile	762.996
Maximum	1305.19
Range	1289.5
Interquartile range (IQR)	263.76

Descriptive statistics

Standard deviation	208.87487
Coefficient of variation (CV)	0.64355939
Kurtosis	1.2468013
Mean	324.56192
Median Absolute Deviation (MAD)	123.2
Skewness	1.1284191
Sum	12890626
Variance	43628.713
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
311.11	68	0.2%
180.96	59	0.1%
311.02	54	0.1%
150.8	48	0.1%
368.45	46	0.1%
372.12	45	0.1%
330.76	43	0.1%
339.31	42	0.1%
301.6	41	0.1%
317.72	41	0.1%
Other values (15373)	39230	98.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
15.69	1	< 0.1%
16.08	1	< 0.1%
16.25	1	< 0.1%
16.31	1	< 0.1%
16.47	1	< 0.1%
19.87	1	< 0.1%
20.22	1	< 0.1%
21.25	1	< 0.1%
21.74	1	< 0.1%
21.81	1	< 0.1%

Value	Count	Frequency (%)
1305.19	1	< 0.1%
1302.69	1	< 0.1%
1295.21	1	< 0.1%
1288.1	2	< 0.1%
1283.5	1	< 0.1%
1276.6	3	< 0.1%
1272.2	1	< 0.1%
1269.73	5	< 0.1%
1265.16	1	< 0.1%
1263.23	1	< 0.1%

grade
Categorical

HIGH CORRELATION

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

B	12020
A	10085
C	8098
D	5307
E	2842
Other values (2)	1365

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	39717
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	B
2nd row	C
3rd row	C
4th row	C
5th row	B

Common Values

Value	Count	Frequency (%)
B	12020	30.3%
A	10085	25.4%
C	8098	20.4%
D	5307	13.4%
E	2842	7.2%
F	1049	2.6%
G	316	0.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
b	12020	30.3%
a	10085	25.4%
c	8098	20.4%
d	5307	13.4%
e	2842	7.2%
f	1049	2.6%
g	316	0.8%

Most occurring characters

Value	Count	Frequency (%)
B	12020	30.3%
A	10085	25.4%
C	8098	20.4%
D	5307	13.4%
E	2842	7.2%
F	1049	2.6%
G	316	0.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	39717	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
B	12020	30.3%
A	10085	25.4%
C	8098	20.4%
D	5307	13.4%
E	2842	7.2%
F	1049	2.6%
G	316	0.8%

Most occurring scripts

Value	Count	Frequency (%)
Latin	39717	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
B	12020	30.3%
A	10085	25.4%
C	8098	20.4%
D	5307	13.4%
E	2842	7.2%
F	1049	2.6%
G	316	0.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	39717	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
B	12020	30.3%
A	10085	25.4%
C	8098	20.4%
D	5307	13.4%
E	2842	7.2%
F	1049	2.6%
G	316	0.8%

sub_grade
Categorical

HIGH CORRELATION

Distinct	35
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

B3	2917
A4	2886
A5	2742
B5	2704
B4	2512
Other values (30)	25956

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	79434
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	B2
2nd row	C4
3rd row	C5
4th row	C1
5th row	B5

Common Values

Value	Count	Frequency (%)
B3	2917	7.3%
A4	2886	7.3%
A5	2742	6.9%
B5	2704	6.8%
B4	2512	6.3%
C1	2136	5.4%
B2	2057	5.2%
C2	2011	5.1%
B1	1830	4.6%
A3	1810	4.6%
Other values (25)	16112	40.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
b3	2917	7.3%
a4	2886	7.3%
a5	2742	6.9%
b5	2704	6.8%
b4	2512	6.3%
c1	2136	5.4%
b2	2057	5.2%
c2	2011	5.1%
b1	1830	4.6%
a3	1810	4.6%
Other values (25)	16112	40.6%

Most occurring characters

Value	Count	Frequency (%)
B	12020	15.1%
A	10085	12.7%
4	8293	10.4%
3	8215	10.3%
C	8098	10.2%
5	8070	10.2%
2	7907	10.0%
1	7232	9.1%
D	5307	6.7%
E	2842	3.6%
Other values (2)	1365	1.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	39717	50.0%
Decimal Number	39717	50.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
B	12020	30.3%
A	10085	25.4%
C	8098	20.4%
D	5307	13.4%
E	2842	7.2%
F	1049	2.6%
G	316	0.8%

Decimal Number

Value	Count	Frequency (%)
4	8293	20.9%
3	8215	20.7%
5	8070	20.3%
2	7907	19.9%
1	7232	18.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	39717	50.0%
Common	39717	50.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
B	12020	30.3%
A	10085	25.4%
C	8098	20.4%
D	5307	13.4%
E	2842	7.2%
F	1049	2.6%
G	316	0.8%

Common

Value	Count	Frequency (%)
4	8293	20.9%
3	8215	20.7%
5	8070	20.3%
2	7907	19.9%
1	7232	18.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	79434	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
B	12020	15.1%
A	10085	12.7%
4	8293	10.4%
3	8215	10.3%
C	8098	10.2%
5	8070	10.2%
2	7907	10.0%
1	7232	9.1%
D	5307	6.7%
E	2842	3.6%
Other values (2)	1365	1.7%

emp_title
Text

MISSING

Distinct	28820
Distinct (%)	77.4%
Missing	2459
Missing (%)	6.2%
Memory size	310.4 KiB

Length

Max length	78
Median length	55
Mean length	18.379784
Min length	2

Characters and Unicode

Total characters	684794
Distinct characters	96
Distinct categories	15 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	25641 ?
Unique (%)	68.8%

Sample

1st row	Ryder
2nd row	AIR RESOURCES BOARD
3rd row	University Medical Group
4th row	Veolia Transportaton
5th row	Southern Star Photography

Value	Count	Frequency (%)
inc	3197	3.2%
of	3008	3.0%
	1208	1.2%
and	963	1.0%
center	818	0.8%
bank	805	0.8%
county	803	0.8%
services	795	0.8%
school	750	0.7%
the	747	0.7%
Other values (18882)	87491	87.0%

Most occurring characters

Value	Count	Frequency (%)
	64766	9.5%
e	55954	8.2%
a	43836	6.4%
n	42641	6.2%
o	42586	6.2%
i	40491	5.9%
r	40067	5.9%
t	38580	5.6%
s	30254	4.4%
l	25923	3.8%
Other values (86)	259696	37.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	489338	71.5%
Uppercase Letter	119545	17.5%
Space Separator	64766	9.5%
Other Punctuation	8798	1.3%
Dash Punctuation	1031	0.2%
Decimal Number	968	0.1%
Open Punctuation	159	< 0.1%
Close Punctuation	156	< 0.1%
Math Symbol	21	< 0.1%
Modifier Symbol	2	< 0.1%
Other values (5)	10	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	14579	12.2%
S	13325	11.1%
A	8885	7.4%
I	7566	6.3%
M	6518	5.5%
P	6077	5.1%
T	5691	4.8%
L	5561	4.7%
E	5241	4.4%
D	5056	4.2%
Other values (18)	41046	34.3%

Lowercase Letter

Value	Count	Frequency (%)
e	55954	11.4%
a	43836	9.0%
n	42641	8.7%
o	42586	8.7%
i	40491	8.3%
r	40067	8.2%
t	38580	7.9%
s	30254	6.2%
l	25923	5.3%
c	23099	4.7%
Other values (17)	105907	21.6%

Other Punctuation

Value	Count	Frequency (%)
.	4253	48.3%
,	2194	24.9%
&	1301	14.8%
'	652	7.4%
/	311	3.5%
#	36	0.4%
@	10	0.1%
:	9	0.1%
"	8	0.1%
!	8	0.1%
Other values (5)	16	0.2%

Decimal Number

Value	Count	Frequency (%)
1	192	19.8%
2	161	16.6%
3	155	16.0%
0	98	10.1%
4	91	9.4%
5	72	7.4%
9	62	6.4%
6	58	6.0%
7	46	4.8%
8	33	3.4%

Math Symbol

Value	Count	Frequency (%)
+	18	85.7%
\|	2	9.5%
<	1	4.8%

Open Punctuation

Value	Count	Frequency (%)
(	158	99.4%
[	1	0.6%

Currency Symbol

Value	Count	Frequency (%)
¢	1	50.0%
$	1	50.0%

Control

Value	Count	Frequency (%)
	1	50.0%
	1	50.0%

Space Separator

Value	Count	Frequency (%)
	64766	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1031	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	156	100.0%

Modifier Symbol

Value	Count	Frequency (%)
`	2	100.0%

Other Symbol

Value	Count	Frequency (%)
©	2	100.0%

Other Number

Value	Count	Frequency (%)
²	2	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	608883	88.9%
Common	75911	11.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	55954	9.2%
a	43836	7.2%
n	42641	7.0%
o	42586	7.0%
i	40491	6.7%
r	40067	6.6%
t	38580	6.3%
s	30254	5.0%
l	25923	4.3%
c	23099	3.8%
Other values (45)	225452	37.0%

Common

Value	Count	Frequency (%)
	64766	85.3%
.	4253	5.6%
,	2194	2.9%
&	1301	1.7%
-	1031	1.4%
'	652	0.9%
/	311	0.4%
1	192	0.3%
2	161	0.2%
(	158	0.2%
Other values (31)	892	1.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	684780	> 99.9%
None	14	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	64766	9.5%
e	55954	8.2%
a	43836	6.4%
n	42641	6.2%
o	42586	6.2%
i	40491	5.9%
r	40067	5.9%
t	38580	5.6%
s	30254	4.4%
l	25923	3.8%
Other values (77)	259682	37.9%

None

Value	Count	Frequency (%)
Ã	3	21.4%
©	2	14.3%
²	2	14.3%
Â	2	14.3%
¢	1	7.1%
	1	7.1%
â	1	7.1%
	1	7.1%
¡	1	7.1%

emp_length
Categorical

MISSING

Distinct	11
Distinct (%)	< 0.1%
Missing	1075
Missing (%)	2.7%
Memory size	310.4 KiB

10+ years	8879
< 1 year	4583
2 years	4388
3 years	4095
4 years	3436
Other values (6)	13261

Length

Max length	9
Median length	7
Mean length	7.4943067
Min length	6

Characters and Unicode

Total characters	289595
Distinct characters	18
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	10+ years
2nd row	< 1 year
3rd row	10+ years
4th row	10+ years
5th row	1 year

Common Values

Value	Count	Frequency (%)
10+ years	8879	22.4%
< 1 year	4583	11.5%
2 years	4388	11.0%
3 years	4095	10.3%
4 years	3436	8.7%
5 years	3282	8.3%
1 year	3240	8.2%
6 years	2229	5.6%
7 years	1773	4.5%
8 years	1479	3.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
years	30819	37.6%
10	8879	10.8%
1	7823	9.6%
year	7823	9.6%
	4583	5.6%
2	4388	5.4%
3	4095	5.0%
4	3436	4.2%
5	3282	4.0%
6	2229	2.7%
Other values (3)	4510	5.5%

Most occurring characters

Value	Count	Frequency (%)
	43225	14.9%
y	38642	13.3%
e	38642	13.3%
a	38642	13.3%
r	38642	13.3%
s	30819	10.6%
1	16702	5.8%
0	8879	3.1%
+	8879	3.1%
<	4583	1.6%
Other values (8)	21940	7.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	185387	64.0%
Decimal Number	47521	16.4%
Space Separator	43225	14.9%
Math Symbol	13462	4.6%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	16702	35.1%
0	8879	18.7%
2	4388	9.2%
3	4095	8.6%
4	3436	7.2%
5	3282	6.9%
6	2229	4.7%
7	1773	3.7%
8	1479	3.1%
9	1258	2.6%

Lowercase Letter

Value	Count	Frequency (%)
y	38642	20.8%
e	38642	20.8%
a	38642	20.8%
r	38642	20.8%
s	30819	16.6%

Math Symbol

Value	Count	Frequency (%)
+	8879	66.0%
<	4583	34.0%

Space Separator

Value	Count	Frequency (%)
	43225	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	185387	64.0%
Common	104208	36.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
	43225	41.5%
1	16702	16.0%
0	8879	8.5%
+	8879	8.5%
<	4583	4.4%
2	4388	4.2%
3	4095	3.9%
4	3436	3.3%
5	3282	3.1%
6	2229	2.1%
Other values (3)	4510	4.3%

Latin

Value	Count	Frequency (%)
y	38642	20.8%
e	38642	20.8%
a	38642	20.8%
r	38642	20.8%
s	30819	16.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	289595	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	43225	14.9%
y	38642	13.3%
e	38642	13.3%
a	38642	13.3%
r	38642	13.3%
s	30819	10.6%
1	16702	5.8%
0	8879	3.1%
+	8879	3.1%
<	4583	1.6%
Other values (8)	21940	7.6%

home_ownership
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

RENT	18899
MORTGAGE	17659
OWN	3058
OTHER	98
NONE	3

Length

Max length	8
Median length	5
Mean length	5.7039555
Min length	3

Characters and Unicode

Total characters	226544
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	RENT
2nd row	RENT
3rd row	RENT
4th row	RENT
5th row	RENT

Common Values

Value	Count	Frequency (%)
RENT	18899	47.6%
MORTGAGE	17659	44.5%
OWN	3058	7.7%
OTHER	98	0.2%
NONE	3	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
rent	18899	47.6%
mortgage	17659	44.5%
own	3058	7.7%
other	98	0.2%
none	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
E	36659	16.2%
R	36656	16.2%
T	36656	16.2%
G	35318	15.6%
N	21963	9.7%
O	20818	9.2%
M	17659	7.8%
A	17659	7.8%
W	3058	1.3%
H	98	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	226544	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	36659	16.2%
R	36656	16.2%
T	36656	16.2%
G	35318	15.6%
N	21963	9.7%
O	20818	9.2%
M	17659	7.8%
A	17659	7.8%
W	3058	1.3%
H	98	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	226544	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	36659	16.2%
R	36656	16.2%
T	36656	16.2%
G	35318	15.6%
N	21963	9.7%
O	20818	9.2%
M	17659	7.8%
A	17659	7.8%
W	3058	1.3%
H	98	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	226544	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	36659	16.2%
R	36656	16.2%
T	36656	16.2%
G	35318	15.6%
N	21963	9.7%
O	20818	9.2%
M	17659	7.8%
A	17659	7.8%
W	3058	1.3%
H	98	< 0.1%

annual_inc
Real number (ℝ)

SKEWED

Distinct	5318
Distinct (%)	13.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	68968.926

Minimum	4000
Maximum	6000000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	310.4 KiB

Quantile statistics

Minimum	4000
5-th percentile	24000
Q1	40404
median	59000
Q3	82300
95-th percentile	142000
Maximum	6000000
Range	5996000
Interquartile range (IQR)	41896

Descriptive statistics

Standard deviation	63793.766
Coefficient of variation (CV)	0.92496388
Kurtosis	2302.7378
Mean	68968.926
Median Absolute Deviation (MAD)	20000
Skewness	30.949185
Sum	2.7392388 × 10⁹
Variance	4.0696446 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
60000	1505	3.8%
50000	1057	2.7%
40000	876	2.2%
45000	830	2.1%
30000	825	2.1%
75000	811	2.0%
65000	803	2.0%
70000	733	1.8%
48000	723	1.8%
80000	662	1.7%
Other values (5308)	30892	77.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4000	1	< 0.1%
4080	1	< 0.1%
4200	2	< 0.1%
4800	4	< 0.1%
4888	1	< 0.1%
5000	1	< 0.1%
5500	1	< 0.1%
6000	5	< 0.1%
7000	1	< 0.1%
7200	4	< 0.1%

Value	Count	Frequency (%)
6000000	1	< 0.1%
3900000	1	< 0.1%
2039784	1	< 0.1%
1900000	1	< 0.1%
1782000	1	< 0.1%
1440000	1	< 0.1%
1362000	1	< 0.1%
1250000	1	< 0.1%
1200000	4	< 0.1%
1176000	1	< 0.1%

verification_status
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

Not Verified	16921
Verified	12809
Source Verified	9987

Length

Max length	15
Median length	12
Mean length	11.464335
Min length	8

Characters and Unicode

Total characters	455329
Distinct characters	13
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Verified
2nd row	Source Verified
3rd row	Not Verified
4th row	Source Verified
5th row	Source Verified

Common Values

Value	Count	Frequency (%)
Not Verified	16921	42.6%
Verified	12809	32.3%
Source Verified	9987	25.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
verified	39717	59.6%
not	16921	25.4%
source	9987	15.0%

Most occurring characters

Value	Count	Frequency (%)
e	89421	19.6%
i	79434	17.4%
r	49704	10.9%
V	39717	8.7%
f	39717	8.7%
d	39717	8.7%
o	26908	5.9%
	26908	5.9%
N	16921	3.7%
t	16921	3.7%
Other values (3)	29961	6.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	361796	79.5%
Uppercase Letter	66625	14.6%
Space Separator	26908	5.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	89421	24.7%
i	79434	22.0%
r	49704	13.7%
f	39717	11.0%
d	39717	11.0%
o	26908	7.4%
t	16921	4.7%
u	9987	2.8%
c	9987	2.8%

Uppercase Letter

Value	Count	Frequency (%)
V	39717	59.6%
N	16921	25.4%
S	9987	15.0%

Space Separator

Value	Count	Frequency (%)
	26908	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	428421	94.1%
Common	26908	5.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	89421	20.9%
i	79434	18.5%
r	49704	11.6%
V	39717	9.3%
f	39717	9.3%
d	39717	9.3%
o	26908	6.3%
N	16921	3.9%
t	16921	3.9%
S	9987	2.3%
Other values (2)	19974	4.7%

Common

Value	Count	Frequency (%)
	26908	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	455329	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	89421	19.6%
i	79434	17.4%
r	49704	10.9%
V	39717	8.7%
f	39717	8.7%
d	39717	8.7%
o	26908	5.9%
	26908	5.9%
N	16921	3.7%
t	16921	3.7%
Other values (3)	29961	6.6%

issue_d
Text

Distinct	55
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	238302
Distinct characters	28
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Dec-11
2nd row	Dec-11
3rd row	Dec-11
4th row	Dec-11
5th row	Dec-11

Value	Count	Frequency (%)
dec-11	2260	5.7%
nov-11	2223	5.6%
oct-11	2114	5.3%
sep-11	2063	5.2%
aug-11	1928	4.9%
jul-11	1870	4.7%
jun-11	1827	4.6%
may-11	1689	4.3%
apr-11	1562	3.9%
mar-11	1443	3.6%
Other values (45)	20738	52.2%

Most occurring characters

Value	Count	Frequency (%)
1	54844	23.0%
-	39717	16.7%
0	18061	7.6%
e	10439	4.4%
u	10273	4.3%
J	9134	3.8%
c	8367	3.5%
a	8070	3.4%
p	6482	2.7%
A	6352	2.7%
Other values (18)	66563	27.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	79434	33.3%
Lowercase Letter	79434	33.3%
Dash Punctuation	39717	16.7%
Uppercase Letter	39717	16.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	10439	13.1%
u	10273	12.9%
c	8367	10.5%
a	8070	10.2%
p	6482	8.2%
n	5658	7.1%
r	5526	7.0%
v	4167	5.2%
o	4167	5.2%
t	3934	5.0%
Other values (4)	12351	15.5%

Uppercase Letter

Value	Count	Frequency (%)
J	9134	23.0%
A	6352	16.0%
M	5691	14.3%
D	4433	11.2%
N	4167	10.5%
O	3934	9.9%
S	3648	9.2%
F	2358	5.9%

Decimal Number

Value	Count	Frequency (%)
1	54844	69.0%
0	18061	22.7%
9	4716	5.9%
8	1562	2.0%
7	251	0.3%

Dash Punctuation

Value	Count	Frequency (%)
-	39717	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	119151	50.0%
Latin	119151	50.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	10439	8.8%
u	10273	8.6%
J	9134	7.7%
c	8367	7.0%
a	8070	6.8%
p	6482	5.4%
A	6352	5.3%
M	5691	4.8%
n	5658	4.7%
r	5526	4.6%
Other values (12)	43159	36.2%

Common

Value	Count	Frequency (%)
1	54844	46.0%
-	39717	33.3%
0	18061	15.2%
9	4716	4.0%
8	1562	1.3%
7	251	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	238302	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	54844	23.0%
-	39717	16.7%
0	18061	7.6%
e	10439	4.4%
u	10273	4.3%
J	9134	3.8%
c	8367	3.5%
a	8070	3.4%
p	6482	2.7%
A	6352	2.7%
Other values (18)	66563	27.9%

loan_status
Categorical

HIGH CORRELATION IMBALANCE

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

Fully Paid	32950
Charged Off	5627
Current	1140

Length

Max length	11
Median length	10
Mean length	10.055568
Min length	7

Characters and Unicode

Total characters	399377
Distinct characters	18
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Fully Paid
2nd row	Charged Off
3rd row	Fully Paid
4th row	Fully Paid
5th row	Current

Common Values

Value	Count	Frequency (%)
Fully Paid	32950	83.0%
Charged Off	5627	14.2%
Current	1140	2.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
fully	32950	42.1%
paid	32950	42.1%
charged	5627	7.2%
off	5627	7.2%
current	1140	1.5%

Most occurring characters

Value	Count	Frequency (%)
l	65900	16.5%
	38577	9.7%
a	38577	9.7%
d	38577	9.7%
u	34090	8.5%
F	32950	8.3%
y	32950	8.3%
P	32950	8.3%
i	32950	8.3%
f	11254	2.8%
Other values (8)	40602	10.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	282506	70.7%
Uppercase Letter	78294	19.6%
Space Separator	38577	9.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
l	65900	23.3%
a	38577	13.7%
d	38577	13.7%
u	34090	12.1%
y	32950	11.7%
i	32950	11.7%
f	11254	4.0%
r	7907	2.8%
e	6767	2.4%
g	5627	2.0%
Other values (3)	7907	2.8%

Uppercase Letter

Value	Count	Frequency (%)
F	32950	42.1%
P	32950	42.1%
C	6767	8.6%
O	5627	7.2%

Space Separator

Value	Count	Frequency (%)
	38577	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	360800	90.3%
Common	38577	9.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
l	65900	18.3%
a	38577	10.7%
d	38577	10.7%
u	34090	9.4%
F	32950	9.1%
y	32950	9.1%
P	32950	9.1%
i	32950	9.1%
f	11254	3.1%
r	7907	2.2%
Other values (7)	32695	9.1%

Common

Value	Count	Frequency (%)
	38577	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	399377	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
l	65900	16.5%
	38577	9.7%
a	38577	9.7%
d	38577	9.7%
u	34090	8.5%
F	32950	8.3%
y	32950	8.3%
P	32950	8.3%
i	32950	8.3%
f	11254	2.8%
Other values (8)	40602	10.2%

pymnt_plan
Boolean

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	38.9 KiB

False	39717

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	39717	100.0%

url
Text

UNIQUE

Distinct	39717
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

Length

Max length	64
Median length	63
Mean length	63.108367
Min length	62

Characters and Unicode

Total characters	2506475
Distinct characters	35
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	39717 ?
Unique (%)	100.0%

Sample

1st row	https://lendingclub.com/browse/loanDetail.action?loan_id=1077501
2nd row	https://lendingclub.com/browse/loanDetail.action?loan_id=1077430
3rd row	https://lendingclub.com/browse/loanDetail.action?loan_id=1077175
4th row	https://lendingclub.com/browse/loanDetail.action?loan_id=1076863
5th row	https://lendingclub.com/browse/loanDetail.action?loan_id=1075358

Value	Count	Frequency (%)
https://lendingclub.com/browse/loandetail.action?loan_id=1077501	1	< 0.1%
https://lendingclub.com/browse/loandetail.action?loan_id=1069639	1	< 0.1%
https://lendingclub.com/browse/loandetail.action?loan_id=1069742	1	< 0.1%
https://lendingclub.com/browse/loandetail.action?loan_id=1062474	1	< 0.1%
https://lendingclub.com/browse/loandetail.action?loan_id=1069971	1	< 0.1%
https://lendingclub.com/browse/loandetail.action?loan_id=1077175	1	< 0.1%
https://lendingclub.com/browse/loandetail.action?loan_id=1076863	1	< 0.1%
https://lendingclub.com/browse/loandetail.action?loan_id=1075358	1	< 0.1%
https://lendingclub.com/browse/loandetail.action?loan_id=1075269	1	< 0.1%
https://lendingclub.com/browse/loandetail.action?loan_id=1072053	1	< 0.1%
Other values (39707)	39707	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
o	198585	7.9%
l	198585	7.9%
n	198585	7.9%
a	158868	6.3%
t	158868	6.3%
/	158868	6.3%
i	158868	6.3%
c	119151	4.8%
e	119151	4.8%
.	79434	3.2%
Other values (25)	957512	38.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1826982	72.9%
Other Punctuation	317736	12.7%
Decimal Number	242606	9.7%
Uppercase Letter	39717	1.6%
Connector Punctuation	39717	1.6%
Math Symbol	39717	1.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	198585	10.9%
l	198585	10.9%
n	198585	10.9%
a	158868	8.7%
t	158868	8.7%
i	158868	8.7%
c	119151	6.5%
e	119151	6.5%
b	79434	4.3%
d	79434	4.3%
Other values (8)	357453	19.6%

Decimal Number

Value	Count	Frequency (%)
5	26616	11.0%
6	26607	11.0%
7	26037	10.7%
8	25774	10.6%
4	25584	10.5%
1	24160	10.0%
0	23856	9.8%
3	22052	9.1%
9	21694	8.9%
2	20226	8.3%

Other Punctuation

Value	Count	Frequency (%)
/	158868	50.0%
.	79434	25.0%
?	39717	12.5%
:	39717	12.5%

Uppercase Letter

Value	Count	Frequency (%)
D	39717	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	39717	100.0%

Math Symbol

Value	Count	Frequency (%)
=	39717	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1866699	74.5%
Common	639776	25.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	198585	10.6%
l	198585	10.6%
n	198585	10.6%
a	158868	8.5%
t	158868	8.5%
i	158868	8.5%
c	119151	6.4%
e	119151	6.4%
b	79434	4.3%
d	79434	4.3%
Other values (9)	397170	21.3%

Common

Value	Count	Frequency (%)
/	158868	24.8%
.	79434	12.4%
?	39717	6.2%
_	39717	6.2%
=	39717	6.2%
:	39717	6.2%
5	26616	4.2%
6	26607	4.2%
7	26037	4.1%
8	25774	4.0%
Other values (6)	137572	21.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2506475	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	198585	7.9%
l	198585	7.9%
n	198585	7.9%
a	158868	6.3%
t	158868	6.3%
/	158868	6.3%
i	158868	6.3%
c	119151	4.8%
e	119151	4.8%
.	79434	3.2%
Other values (25)	957512	38.2%

desc
Text

MISSING

Distinct	26527
Distinct (%)	99.1%
Missing	12940
Missing (%)	32.6%
Memory size	310.4 KiB

Length

Max length	3988
Median length	2248
Mean length	426.49404
Min length	1

Characters and Unicode

Total characters	11420231
Distinct characters	142
Distinct categories	17 ?
Distinct scripts	2 ?
Distinct blocks	4 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	26499 ?
Unique (%)	99.0%

Sample

1st row	Borrower added on 12/22/11 > I need to upgrade my business technologies.<br>
2nd row	Borrower added on 12/22/11 > I plan to use this money to finance the motorcycle i am looking at. I plan to have it paid off as soon as possible/when i sell my old bike. I only need this money because the deal im looking at is to good to pass up.<br><br> Borrower added on 12/22/11 > I plan to use this money to finance the motorcycle i am looking at. I plan to have it paid off as soon as possible/when i sell my old bike.I only need this money because the deal im looking at is to good to pass up. I have finished college with an associates degree in business and its takingmeplaces<br>
3rd row	Borrower added on 12/21/11 > to pay for property tax (borrow from friend, need to pay back) & central A/C need to be replace. I'm very sorry to let my loan expired last time.<br>
4th row	Borrower added on 12/21/11 > I plan on combining three large interest bills together and freeing up some extra each month to pay toward other bills. I've always been a good payor but have found myself needing to make adjustments to my budget due to a medical scare. My job is very stable, I love it.<br>
5th row	Borrower added on 12/18/11 > I am planning on using the funds to pay off two retail credit cards with 24.99% interest rates, as well as a major bank credit card with a 18.99% rate. I pay all my bills on time, looking for a lower combined payment and lower monthly payment.<br>

Value	Count	Frequency (%)
i	77512	3.8%
to	71096	3.5%
a	54855	2.7%
the	54340	2.7%
and	54329	2.6%
my	51308	2.5%
on	49132	2.4%
	37238	1.8%
for	32774	1.6%
have	32490	1.6%
Other values (53986)	1535186	74.9%

Most occurring characters

Value	Count	Frequency (%)
	2121185	18.6%
e	953964	8.4%
a	714029	6.3%
o	709013	6.2%
t	649103	5.7%
n	612137	5.4%
r	589058	5.2%
i	496003	4.3%
s	426272	3.7%
d	397984	3.5%
Other values (132)	3751483	32.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	8135704	71.2%
Space Separator	2121258	18.6%
Decimal Number	346663	3.0%
Other Punctuation	326744	2.9%
Uppercase Letter	302772	2.7%
Math Symbol	140645	1.2%
Currency Symbol	16745	0.1%
Dash Punctuation	13032	0.1%
Close Punctuation	7337	0.1%
Open Punctuation	6727	0.1%
Other values (7)	2604	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	94559	31.2%
B	34778	11.5%
T	28474	9.4%
A	15522	5.1%
C	14303	4.7%
M	14262	4.7%
S	9642	3.2%
E	9211	3.0%
W	8830	2.9%
L	8656	2.9%
Other values (21)	64535	21.3%

Lowercase Letter

Value	Count	Frequency (%)
e	953964	11.7%
a	714029	8.8%
o	709013	8.7%
t	649103	8.0%
n	612137	7.5%
r	589058	7.2%
i	496003	6.1%
s	426272	5.2%
d	397984	4.9%
l	355636	4.4%
Other values (18)	2232505	27.4%

Other Punctuation

Value	Count	Frequency (%)
.	120658	36.9%
/	116441	35.6%
,	50144	15.3%
'	13317	4.1%
!	6738	2.1%
%	5704	1.7%
:	5281	1.6%
;	3357	1.0%
&	2616	0.8%
"	801	0.2%
Other values (10)	1687	0.5%

Control

Value	Count	Frequency (%)
	1287	60.5%
	411	19.3%
	191	9.0%
	38	1.8%
	37	1.7%
	35	1.6%
	27	1.3%
	27	1.3%
	23	1.1%
	15	0.7%
Other values (9)	37	1.7%

Decimal Number

Value	Count	Frequency (%)
0	104184	30.1%
1	97487	28.1%
2	36710	10.6%
5	21465	6.2%
3	17828	5.1%
9	16291	4.7%
4	13709	4.0%
6	13182	3.8%
7	12927	3.7%
8	12880	3.7%

Math Symbol

Value	Count	Frequency (%)
>	84845	60.3%
<	53870	38.3%
+	984	0.7%
=	615	0.4%
~	290	0.2%
¬	31	< 0.1%
\|	10	< 0.1%

Other Symbol

Value	Count	Frequency (%)
¦	96	83.5%
©	15	13.0%
�	2	1.7%
®	2	1.7%

Dash Punctuation

Value	Count	Frequency (%)
-	13017	99.9%
—	9	0.1%
–	6	< 0.1%

Close Punctuation

Value	Count	Frequency (%)
)	7290	99.4%
]	44	0.6%
}	3	< 0.1%

Open Punctuation

Value	Count	Frequency (%)
(	6681	99.3%
[	44	0.7%
{	2	< 0.1%

Modifier Symbol

Value	Count	Frequency (%)
`	13	68.4%
^	5	26.3%
¯	1	5.3%

Space Separator

Value	Count	Frequency (%)
	2121185	> 99.9%
	73	< 0.1%

Currency Symbol

Value	Count	Frequency (%)
$	16671	99.6%
¢	74	0.4%

Final Punctuation

Value	Count	Frequency (%)
’	78	81.2%
”	18	18.8%

Initial Punctuation

Value	Count	Frequency (%)
“	18	85.7%
‘	3	14.3%

Other Number

Value	Count	Frequency (%)
½	6	75.0%
¾	2	25.0%

Connector Punctuation

Value	Count	Frequency (%)
_	217	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8438476	73.9%
Common	2981755	26.1%

Most frequent character per script

Common

Value	Count	Frequency (%)
	2121185	71.1%
.	120658	4.0%
/	116441	3.9%
0	104184	3.5%
1	97487	3.3%
>	84845	2.8%
<	53870	1.8%
,	50144	1.7%
2	36710	1.2%
5	21465	0.7%
Other values (73)	174766	5.9%

Latin

Value	Count	Frequency (%)
e	953964	11.3%
a	714029	8.5%
o	709013	8.4%
t	649103	7.7%
n	612137	7.3%
r	589058	7.0%
i	496003	5.9%
s	426272	5.1%
d	397984	4.7%
l	355636	4.2%
Other values (49)	2535277	30.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11418236	> 99.9%
None	1834	< 0.1%
Punctuation	159	< 0.1%
Specials	2	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	2121185	18.6%
e	953964	8.4%
a	714029	6.3%
o	709013	6.2%
t	649103	5.7%
n	612137	5.4%
r	589058	5.2%
i	496003	4.3%
s	426272	3.7%
d	397984	3.5%
Other values (86)	3749488	32.8%

None

Value	Count	Frequency (%)
â	438	23.9%
	411	22.4%
	191	10.4%
Â	127	6.9%
Ã	97	5.3%
¦	96	5.2%
¢	74	4.0%
	73	4.0%
	38	2.1%
	37	2.0%
Other values (27)	252	13.7%

Punctuation

Value	Count	Frequency (%)
’	78	49.1%
…	19	11.9%
“	18	11.3%
”	18	11.3%
—	9	5.7%
•	8	5.0%
–	6	3.8%
‘	3	1.9%

Specials

Value	Count	Frequency (%)
�	2	100.0%

purpose
Categorical

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

debt_consolidation	18641
credit_card	5130
other	3993
home_improvement	2976
major_purchase	2187
Other values (9)	6790

Length

Max length	18
Median length	16
Mean length	13.736183
Min length	3

Characters and Unicode

Total characters	545560
Distinct characters	22
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	credit_card
2nd row	car
3rd row	small_business
4th row	other
5th row	other

Common Values

Value	Count	Frequency (%)
debt_consolidation	18641	46.9%
credit_card	5130	12.9%
other	3993	10.1%
home_improvement	2976	7.5%
major_purchase	2187	5.5%
small_business	1828	4.6%
car	1549	3.9%
wedding	947	2.4%
medical	693	1.7%
moving	583	1.5%
Other values (4)	1190	3.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
debt_consolidation	18641	46.9%
credit_card	5130	12.9%
other	3993	10.1%
home_improvement	2976	7.5%
major_purchase	2187	5.5%
small_business	1828	4.6%
car	1549	3.9%
wedding	947	2.4%
medical	693	1.7%
moving	583	1.5%
Other values (4)	1190	3.0%

Most occurring characters

Value	Count	Frequency (%)
o	69725	12.8%
d	50454	9.2%
i	50145	9.2%
t	50087	9.2%
n	44528	8.2%
e	43568	8.0%
c	34036	6.2%
a	33730	6.2%
_	30865	5.7%
s	28521	5.2%
Other values (12)	109901	20.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	514695	94.3%
Connector Punctuation	30865	5.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	69725	13.5%
d	50454	9.8%
i	50145	9.7%
t	50087	9.7%
n	44528	8.7%
e	43568	8.5%
c	34036	6.6%
a	33730	6.6%
s	28521	5.5%
l	23418	4.5%
Other values (11)	86483	16.8%

Connector Punctuation

Value	Count	Frequency (%)
_	30865	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	514695	94.3%
Common	30865	5.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	69725	13.5%
d	50454	9.8%
i	50145	9.7%
t	50087	9.7%
n	44528	8.7%
e	43568	8.5%
c	34036	6.6%
a	33730	6.6%
s	28521	5.5%
l	23418	4.5%
Other values (11)	86483	16.8%

Common

Value	Count	Frequency (%)
_	30865	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	545560	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	69725	12.8%
d	50454	9.2%
i	50145	9.2%
t	50087	9.2%
n	44528	8.2%
e	43568	8.0%
c	34036	6.2%
a	33730	6.2%
_	30865	5.7%
s	28521	5.2%
Other values (12)	109901	20.1%

title
Text

Distinct	19615
Distinct (%)	49.4%
Missing	11
Missing (%)	< 0.1%
Memory size	310.4 KiB

Length

Max length	80
Median length	72
Mean length	17.187327
Min length	1

Characters and Unicode

Total characters	682440
Distinct characters	108
Distinct categories	15 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	17624 ?
Unique (%)	44.4%

Sample

1st row	Computer
2nd row	bike
3rd row	real estate business
4th row	personel
5th row	Personal

Value	Count	Frequency (%)
loan	10895	10.4%
debt	9245	8.8%
consolidation	8622	8.2%
credit	4604	4.4%
card	3341	3.2%
personal	2043	2.0%
home	1875	1.8%
pay	1344	1.3%
off	1259	1.2%
my	1133	1.1%
Other values (8935)	60203	57.6%

Most occurring characters

Value	Count	Frequency (%)
	66029	9.7%
o	65729	9.6%
n	55657	8.2%
e	54557	8.0%
a	50167	7.4%
i	43822	6.4%
t	42600	6.2%
d	30679	4.5%
r	29153	4.3%
s	28544	4.2%
Other values (98)	215503	31.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	521300	76.4%
Uppercase Letter	83242	12.2%
Space Separator	66029	9.7%
Decimal Number	5995	0.9%
Other Punctuation	4442	0.7%
Dash Punctuation	824	0.1%
Connector Punctuation	213	< 0.1%
Close Punctuation	104	< 0.1%
Currency Symbol	94	< 0.1%
Math Symbol	92	< 0.1%
Other values (5)	105	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	65729	12.6%
n	55657	10.7%
e	54557	10.5%
a	50167	9.6%
i	43822	8.4%
t	42600	8.2%
d	30679	5.9%
r	29153	5.6%
s	28544	5.5%
l	26300	5.0%
Other values (18)	94092	18.0%

Uppercase Letter

Value	Count	Frequency (%)
C	18509	22.2%
L	10335	12.4%
D	9244	11.1%
P	5641	6.8%
R	3732	4.5%
M	3256	3.9%
S	3227	3.9%
B	3116	3.7%
H	2910	3.5%
I	2885	3.5%
Other values (18)	20387	24.5%

Other Punctuation

Value	Count	Frequency (%)
!	1123	25.3%
'	982	22.1%
.	712	16.0%
/	538	12.1%
,	435	9.8%
&	328	7.4%
%	95	2.1%
:	64	1.4%
"	56	1.3%
?	25	0.6%
Other values (5)	84	1.9%

Decimal Number

Value	Count	Frequency (%)
1	1691	28.2%
0	1677	28.0%
2	1105	18.4%
3	299	5.0%
5	256	4.3%
9	254	4.2%
4	216	3.6%
6	178	3.0%
8	169	2.8%
7	150	2.5%

Control

Value	Count	Frequency (%)
	4	21.1%
	4	21.1%
	4	21.1%
	2	10.5%
	2	10.5%
	1	5.3%
	1	5.3%
	1	5.3%

Math Symbol

Value	Count	Frequency (%)
+	53	57.6%
=	19	20.7%
<	9	9.8%
>	8	8.7%
~	2	2.2%
\|	1	1.1%

Modifier Symbol

Value	Count	Frequency (%)
^	1	33.3%
´	1	33.3%
`	1	33.3%

Close Punctuation

Value	Count	Frequency (%)
)	100	96.2%
]	4	3.8%

Open Punctuation

Value	Count	Frequency (%)
(	77	96.2%
[	3	3.8%

Space Separator

Value	Count	Frequency (%)
	66029	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	824	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	213	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	94	100.0%

Other Symbol

Value	Count	Frequency (%)
¦	2	100.0%

Other Number

Value	Count	Frequency (%)
³	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	604542	88.6%
Common	77898	11.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	65729	10.9%
n	55657	9.2%
e	54557	9.0%
a	50167	8.3%
i	43822	7.2%
t	42600	7.0%
d	30679	5.1%
r	29153	4.8%
s	28544	4.7%
l	26300	4.4%
Other values (46)	177334	29.3%

Common

Value	Count	Frequency (%)
	66029	84.8%
1	1691	2.2%
0	1677	2.2%
!	1123	1.4%
2	1105	1.4%
'	982	1.3%
-	824	1.1%
.	712	0.9%
/	538	0.7%
,	435	0.6%
Other values (42)	2782	3.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	682408	> 99.9%
None	32	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	66029	9.7%
o	65729	9.6%
n	55657	8.2%
e	54557	8.0%
a	50167	7.4%
i	43822	6.4%
t	42600	6.2%
d	30679	4.5%
r	29153	4.3%
s	28544	4.2%
Other values (84)	215471	31.6%

None

Value	Count	Frequency (%)
â	4	12.5%
	4	12.5%
	4	12.5%
	4	12.5%
î	4	12.5%
¦	2	6.2%
	2	6.2%
Ã	2	6.2%
´	1	3.1%
Â	1	3.1%
Other values (4)	4	12.5%

zip_code
Text

Distinct	823
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	198585
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	55 ?
Unique (%)	0.1%

Sample

1st row	860xx
2nd row	309xx
3rd row	606xx
4th row	917xx
5th row	972xx

Value	Count	Frequency (%)
100xx	597	1.5%
945xx	545	1.4%
112xx	516	1.3%
606xx	503	1.3%
070xx	473	1.2%
900xx	453	1.1%
021xx	397	1.0%
300xx	394	1.0%
926xx	371	0.9%
750xx	367	0.9%
Other values (813)	35101	88.4%

Most occurring characters

Value	Count	Frequency (%)
x	79434	40.0%
0	19773	10.0%
1	15629	7.9%
2	13589	6.8%
9	12681	6.4%
3	12356	6.2%
7	10257	5.2%
4	9121	4.6%
5	9020	4.5%
8	8670	4.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	119151	60.0%
Lowercase Letter	79434	40.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	19773	16.6%
1	15629	13.1%
2	13589	11.4%
9	12681	10.6%
3	12356	10.4%
7	10257	8.6%
4	9121	7.7%
5	9020	7.6%
8	8670	7.3%
6	8055	6.8%

Lowercase Letter

Value	Count	Frequency (%)
x	79434	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	119151	60.0%
Latin	79434	40.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	19773	16.6%
1	15629	13.1%
2	13589	11.4%
9	12681	10.6%
3	12356	10.4%
7	10257	8.6%
4	9121	7.7%
5	9020	7.6%
8	8670	7.3%
6	8055	6.8%

Latin

Value	Count	Frequency (%)
x	79434	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	198585	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
x	79434	40.0%
0	19773	10.0%
1	15629	7.9%
2	13589	6.8%
9	12681	6.4%
3	12356	6.2%
7	10257	5.2%
4	9121	4.6%
5	9020	4.5%
8	8670	4.4%

addr_state
Categorical

Distinct	50
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

CA	7099
NY	3812
FL	2866
TX	2727
NJ	1850
Other values (45)	21363

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	79434
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	AZ
2nd row	GA
3rd row	IL
4th row	CA
5th row	OR

Common Values

Value	Count	Frequency (%)
CA	7099	17.9%
NY	3812	9.6%
FL	2866	7.2%
TX	2727	6.9%
NJ	1850	4.7%
IL	1525	3.8%
PA	1517	3.8%
VA	1407	3.5%
GA	1398	3.5%
MA	1340	3.4%
Other values (40)	14176	35.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ca	7099	17.9%
ny	3812	9.6%
fl	2866	7.2%
tx	2727	6.9%
nj	1850	4.7%
il	1525	3.8%
pa	1517	3.8%
va	1407	3.5%
ga	1398	3.5%
ma	1340	3.4%
Other values (40)	14176	35.7%

Most occurring characters

Value	Count	Frequency (%)
A	15698	19.8%
C	10116	12.7%
N	7953	10.0%
L	5279	6.6%
M	4706	5.9%
Y	4220	5.3%
T	3892	4.9%
O	3451	4.3%
I	3097	3.9%
F	2866	3.6%
Other values (14)	18156	22.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	79434	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	15698	19.8%
C	10116	12.7%
N	7953	10.0%
L	5279	6.6%
M	4706	5.9%
Y	4220	5.3%
T	3892	4.9%
O	3451	4.3%
I	3097	3.9%
F	2866	3.6%
Other values (14)	18156	22.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	79434	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	15698	19.8%
C	10116	12.7%
N	7953	10.0%
L	5279	6.6%
M	4706	5.9%
Y	4220	5.3%
T	3892	4.9%
O	3451	4.3%
I	3097	3.9%
F	2866	3.6%
Other values (14)	18156	22.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	79434	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	15698	19.8%
C	10116	12.7%
N	7953	10.0%
L	5279	6.6%
M	4706	5.9%
Y	4220	5.3%
T	3892	4.9%
O	3451	4.3%
I	3097	3.9%
F	2866	3.6%
Other values (14)	18156	22.9%

dti
Real number (ℝ)

Distinct	2868
Distinct (%)	7.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.31513

Minimum	0
Maximum	29.99
Zeros	183
Zeros (%)	0.5%
Negative	0
Negative (%)	0.0%
Memory size	310.4 KiB

Quantile statistics

Minimum	0
5-th percentile	2.13
Q1	8.17
median	13.4
Q3	18.6
95-th percentile	23.84
Maximum	29.99
Range	29.99
Interquartile range (IQR)	10.43

Descriptive statistics

Standard deviation	6.6785936
Coefficient of variation (CV)	0.50157932
Kurtosis	-0.85201548
Mean	13.31513
Median Absolute Deviation (MAD)	5.21
Skewness	-0.028043331
Sum	528837
Variance	44.603612
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	183	0.5%
12	51	0.1%
18	45	0.1%
19.2	40	0.1%
13.2	39	0.1%
12.48	38	0.1%
16.8	38	0.1%
13.5	38	0.1%
6	37	0.1%
15	36	0.1%
Other values (2858)	39172	98.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	183	0.5%
0.01	3	< 0.1%
0.02	5	< 0.1%
0.03	2	< 0.1%
0.04	3	< 0.1%
0.05	2	< 0.1%
0.06	1	< 0.1%
0.07	5	< 0.1%
0.08	5	< 0.1%
0.09	3	< 0.1%

Value	Count	Frequency (%)
29.99	1	< 0.1%
29.95	1	< 0.1%
29.93	3	< 0.1%
29.92	2	< 0.1%
29.89	1	< 0.1%
29.88	1	< 0.1%
29.86	2	< 0.1%
29.85	1	< 0.1%
29.83	1	< 0.1%
29.82	1	< 0.1%

delinq_2yrs
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.14651157

Minimum	0
Maximum	11
Zeros	35405
Zeros (%)	89.1%
Negative	0
Negative (%)	0.0%
Memory size	310.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	11
Range	11
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.49181152
Coefficient of variation (CV)	3.3568101
Kurtosis	39.4125
Mean	0.14651157
Median Absolute Deviation (MAD)	0
Skewness	5.0220352
Sum	5819
Variance	0.24187857
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
0	35405	89.1%
1	3303	8.3%
2	687	1.7%
3	220	0.6%
4	62	0.2%
5	22	0.1%
6	10	< 0.1%
7	4	< 0.1%
8	2	< 0.1%
9	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	35405	89.1%
1	3303	8.3%
2	687	1.7%
3	220	0.6%
4	62	0.2%
5	22	0.1%
6	10	< 0.1%
7	4	< 0.1%
8	2	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
11	1	< 0.1%
9	1	< 0.1%
8	2	< 0.1%
7	4	< 0.1%
6	10	< 0.1%
5	22	0.1%
4	62	0.2%
3	220	0.6%
2	687	1.7%
1	3303	8.3%

earliest_cr_line
Text

Distinct	526
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	238302
Distinct characters	33
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	33 ?
Unique (%)	0.1%

Sample

1st row	Jan-85
2nd row	Apr-99
3rd row	Nov-01
4th row	Feb-96
5th row	Jan-96

Value	Count	Frequency (%)
nov-98	370	0.9%
oct-99	366	0.9%
dec-98	348	0.9%
oct-00	346	0.9%
dec-97	329	0.8%
nov-00	320	0.8%
nov-99	319	0.8%
sep-00	306	0.8%
oct-98	305	0.8%
nov-97	298	0.8%
Other values (516)	36410	91.7%

Most occurring characters

Value	Count	Frequency (%)
-	39717	16.7%
9	23353	9.8%
0	19365	8.1%
e	10541	4.4%
J	9426	4.0%
u	9302	3.9%
a	9126	3.8%
8	8453	3.5%
c	8143	3.4%
n	6364	2.7%
Other values (23)	94512	39.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	79434	33.3%
Lowercase Letter	79434	33.3%
Dash Punctuation	39717	16.7%
Uppercase Letter	39717	16.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	10541	13.3%
u	9302	11.7%
a	9126	11.5%
c	8143	10.3%
n	6364	8.0%
p	6335	8.0%
r	5536	7.0%
t	4076	5.1%
o	3930	4.9%
v	3930	4.9%
Other values (4)	12151	15.3%

Decimal Number

Value	Count	Frequency (%)
9	23353	29.4%
0	19365	24.4%
8	8453	10.6%
7	4822	6.1%
4	4274	5.4%
5	4201	5.3%
6	4174	5.3%
3	3784	4.8%
1	3736	4.7%
2	3272	4.1%

Uppercase Letter

Value	Count	Frequency (%)
J	9426	23.7%
A	6047	15.2%
M	5697	14.3%
O	4076	10.3%
D	4067	10.2%
N	3930	9.9%
S	3593	9.0%
F	2881	7.3%

Dash Punctuation

Value	Count	Frequency (%)
-	39717	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	119151	50.0%
Latin	119151	50.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	10541	8.8%
J	9426	7.9%
u	9302	7.8%
a	9126	7.7%
c	8143	6.8%
n	6364	5.3%
p	6335	5.3%
A	6047	5.1%
M	5697	4.8%
r	5536	4.6%
Other values (12)	42634	35.8%

Common

Value	Count	Frequency (%)
-	39717	33.3%
9	23353	19.6%
0	19365	16.3%
8	8453	7.1%
7	4822	4.0%
4	4274	3.6%
5	4201	3.5%
6	4174	3.5%
3	3784	3.2%
1	3736	3.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	238302	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
-	39717	16.7%
9	23353	9.8%
0	19365	8.1%
e	10541	4.4%
J	9426	4.0%
u	9302	3.9%
a	9126	3.8%
8	8453	3.5%
c	8143	3.4%
n	6364	2.7%
Other values (23)	94512	39.7%

inq_last_6mths
Real number (ℝ)

ZEROS

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.86919959

Minimum	0
Maximum	8
Zeros	19300
Zeros (%)	48.6%
Negative	0
Negative (%)	0.0%
Memory size	310.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	1
95-th percentile	3
Maximum	8
Range	8
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.0702193
Coefficient of variation (CV)	1.23127
Kurtosis	2.5621599
Mean	0.86919959
Median Absolute Deviation (MAD)	1
Skewness	1.3903909
Sum	34522
Variance	1.1453694
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
0	19300	48.6%
1	10971	27.6%
2	5812	14.6%
3	3048	7.7%
4	326	0.8%
5	146	0.4%
6	64	0.2%
7	35	0.1%
8	15	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	19300	48.6%
1	10971	27.6%
2	5812	14.6%
3	3048	7.7%
4	326	0.8%
5	146	0.4%
6	64	0.2%
7	35	0.1%
8	15	< 0.1%

Value	Count	Frequency (%)
8	15	< 0.1%
7	35	0.1%
6	64	0.2%
5	146	0.4%
4	326	0.8%
3	3048	7.7%
2	5812	14.6%
1	10971	27.6%
0	19300	48.6%

mths_since_last_delinq
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	95
Distinct (%)	0.7%
Missing	25682
Missing (%)	64.7%
Infinite	0
Infinite (%)	0.0%
Mean	35.900962

Minimum	0
Maximum	120
Zeros	443
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	310.4 KiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	18
median	34
Q3	52
95-th percentile	75
Maximum	120
Range	120
Interquartile range (IQR)	34

Descriptive statistics

Standard deviation	22.02006
Coefficient of variation (CV)	0.6133557
Kurtosis	-0.84257778
Mean	35.900962
Median Absolute Deviation (MAD)	17
Skewness	0.30643687
Sum	503870
Variance	484.88302
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	443	1.1%
15	252	0.6%
30	247	0.6%
23	247	0.6%
24	241	0.6%
19	238	0.6%
38	237	0.6%
20	233	0.6%
18	231	0.6%
22	231	0.6%
Other values (85)	11435	28.8%
(Missing)	25682	64.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	443	1.1%
1	30	0.1%
2	101	0.3%
3	145	0.4%
4	153	0.4%
5	151	0.4%
6	192	0.5%
7	176	0.4%
8	168	0.4%
9	182	0.5%

Value	Count	Frequency (%)
120	1	< 0.1%
115	1	< 0.1%
107	1	< 0.1%
106	1	< 0.1%
103	2	< 0.1%
97	1	< 0.1%
96	1	< 0.1%
95	1	< 0.1%
89	1	< 0.1%
86	2	< 0.1%

mths_since_last_record
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	111
Distinct (%)	4.0%
Missing	36931
Missing (%)	93.0%
Infinite	0
Infinite (%)	0.0%
Mean	69.698134

Minimum	0
Maximum	129
Zeros	670
Zeros (%)	1.7%
Negative	0
Negative (%)	0.0%
Memory size	310.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	22
median	90
Q3	104
95-th percentile	115
Maximum	129
Range	129
Interquartile range (IQR)	82

Descriptive statistics

Standard deviation	43.822529
Coefficient of variation (CV)	0.62874753
Kurtosis	-1.1565557
Mean	69.698134
Median Absolute Deviation (MAD)	20
Skewness	-0.71722858
Sum	194179
Variance	1920.4141
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	670	1.7%
104	61	0.2%
89	60	0.2%
113	59	0.1%
111	57	0.1%
94	55	0.1%
108	55	0.1%
93	54	0.1%
87	54	0.1%
100	53	0.1%
Other values (101)	1608	4.0%
(Missing)	36931	93.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	670	1.7%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
11	2	< 0.1%
12	1	< 0.1%
13	2	< 0.1%
14	1	< 0.1%
17	3	< 0.1%
18	2	< 0.1%

Value	Count	Frequency (%)
129	1	< 0.1%
120	1	< 0.1%
119	10	< 0.1%
118	36	0.1%
117	47	0.1%
116	41	0.1%
115	37	0.1%
114	51	0.1%
113	59	0.1%
112	39	0.1%

open_acc
Real number (ℝ)

HIGH CORRELATION

Distinct	40
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.2944079

Minimum	2
Maximum	44
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	310.4 KiB

Quantile statistics

Minimum	2
5-th percentile	3
Q1	6
median	9
Q3	12
95-th percentile	17
Maximum	44
Range	42
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	4.4002825
Coefficient of variation (CV)	0.47343333
Kurtosis	1.677572
Mean	9.2944079
Median Absolute Deviation (MAD)	3
Skewness	1.0037619
Sum	369146
Variance	19.362486
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=40)

Value	Count	Frequency (%)
7	4018	10.1%
6	3946	9.9%
8	3936	9.9%
9	3718	9.4%
10	3223	8.1%
5	3183	8.0%
11	2746	6.9%
4	2343	5.9%
12	2273	5.7%
13	1911	4.8%
Other values (30)	8420	21.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	605	1.5%
3	1493	3.8%
4	2343	5.9%
5	3183	8.0%
6	3946	9.9%
7	4018	10.1%
8	3936	9.9%
9	3718	9.4%
10	3223	8.1%
11	2746	6.9%

Value	Count	Frequency (%)
44	1	< 0.1%
42	1	< 0.1%
41	1	< 0.1%
39	1	< 0.1%
38	1	< 0.1%
36	2	< 0.1%
35	4	< 0.1%
34	5	< 0.1%
33	3	< 0.1%
32	4	< 0.1%

pub_rec
Categorical

HIGH CORRELATION IMBALANCE

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

0	37601
1	2056
2	51
3	7
4	2

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	39717
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	37601	94.7%
1	2056	5.2%
2	51	0.1%
3	7	< 0.1%
4	2	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	37601	94.7%
1	2056	5.2%
2	51	0.1%
3	7	< 0.1%
4	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	37601	94.7%
1	2056	5.2%
2	51	0.1%
3	7	< 0.1%
4	2	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	39717	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	37601	94.7%
1	2056	5.2%
2	51	0.1%
3	7	< 0.1%
4	2	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	39717	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	37601	94.7%
1	2056	5.2%
2	51	0.1%
3	7	< 0.1%
4	2	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	39717	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	37601	94.7%
1	2056	5.2%
2	51	0.1%
3	7	< 0.1%
4	2	< 0.1%

revol_bal
Real number (ℝ)

ZEROS

Distinct	21711
Distinct (%)	54.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13382.528

Minimum	0
Maximum	149588
Zeros	994
Zeros (%)	2.5%
Negative	0
Negative (%)	0.0%
Memory size	310.4 KiB

Quantile statistics

Minimum	0
5-th percentile	321.8
Q1	3703
median	8850
Q3	17058
95-th percentile	41656.4
Maximum	149588
Range	149588
Interquartile range (IQR)	13355

Descriptive statistics

Standard deviation	15885.017
Coefficient of variation (CV)	1.1869967
Kurtosis	14.896523
Mean	13382.528
Median Absolute Deviation (MAD)	6027
Skewness	3.1908837
Sum	5.3151387 × 10⁸
Variance	2.5233375 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	994	2.5%
298	14	< 0.1%
255	14	< 0.1%
1	12	< 0.1%
682	11	< 0.1%
52	9	< 0.1%
6	9	< 0.1%
346	9	< 0.1%
39	9	< 0.1%
10	9	< 0.1%
Other values (21701)	38627	97.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	994	2.5%
1	12	< 0.1%
2	5	< 0.1%
3	6	< 0.1%
4	3	< 0.1%
5	8	< 0.1%
6	9	< 0.1%
7	5	< 0.1%
8	5	< 0.1%
9	8	< 0.1%

Value	Count	Frequency (%)
149588	1	< 0.1%
149527	1	< 0.1%
149000	1	< 0.1%
148829	1	< 0.1%
148804	1	< 0.1%
147897	1	< 0.1%
147750	1	< 0.1%
147559	1	< 0.1%
147451	1	< 0.1%
147365	1	< 0.1%

revol_util
Text

Distinct	1089
Distinct (%)	2.7%
Missing	50
Missing (%)	0.1%
Memory size	310.4 KiB

Length

Max length	6
Median length	6
Mean length	5.52192
Min length	2

Characters and Unicode

Total characters	219038
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	89 ?
Unique (%)	0.2%

Sample

1st row	83.70%
2nd row	9.40%
3rd row	98.50%
4th row	21%
5th row	53.90%

Value	Count	Frequency (%)
0	977	2.5%
0.20	63	0.2%
63	62	0.2%
0.10	58	0.1%
66.70	58	0.1%
40.70	58	0.1%
31.20	57	0.1%
46.40	57	0.1%
66.60	57	0.1%
61	57	0.1%
Other values (1079)	38163	96.2%

Most occurring characters

Value	Count	Frequency (%)
0	39671	18.1%
%	39667	18.1%
.	34841	15.9%
4	12082	5.5%
5	12063	5.5%
6	11989	5.5%
7	11949	5.5%
3	11885	5.4%
2	11550	5.3%
8	11419	5.2%
Other values (2)	21922	10.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	144530	66.0%
Other Punctuation	74508	34.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	39671	27.4%
4	12082	8.4%
5	12063	8.3%
6	11989	8.3%
7	11949	8.3%
3	11885	8.2%
2	11550	8.0%
8	11419	7.9%
1	11111	7.7%
9	10811	7.5%

Other Punctuation

Value	Count	Frequency (%)
%	39667	53.2%
.	34841	46.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	219038	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	39671	18.1%
%	39667	18.1%
.	34841	15.9%
4	12082	5.5%
5	12063	5.5%
6	11989	5.5%
7	11949	5.5%
3	11885	5.4%
2	11550	5.3%
8	11419	5.2%
Other values (2)	21922	10.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	219038	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	39671	18.1%
%	39667	18.1%
.	34841	15.9%
4	12082	5.5%
5	12063	5.5%
6	11989	5.5%
7	11949	5.5%
3	11885	5.4%
2	11550	5.3%
8	11419	5.2%
Other values (2)	21922	10.0%

total_acc
Real number (ℝ)

HIGH CORRELATION

Distinct	82
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22.088828

Minimum	2
Maximum	90
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	310.4 KiB

Quantile statistics

Minimum	2
5-th percentile	7
Q1	13
median	20
Q3	29
95-th percentile	43
Maximum	90
Range	88
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	11.401709
Coefficient of variation (CV)	0.51617534
Kurtosis	0.6937402
Mean	22.088828
Median Absolute Deviation (MAD)	7
Skewness	0.82737909
Sum	877302
Variance	129.99896
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16	1471	3.7%
15	1462	3.7%
17	1457	3.7%
14	1445	3.6%
20	1428	3.6%
18	1422	3.6%
21	1412	3.6%
13	1385	3.5%
19	1341	3.4%
12	1325	3.3%
Other values (72)	25569	64.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	4	< 0.1%
3	182	0.5%
4	420	1.1%
5	552	1.4%
6	683	1.7%
7	828	2.1%
8	1006	2.5%
9	1080	2.7%
10	1193	3.0%
11	1278	3.2%

Value	Count	Frequency (%)
90	1	< 0.1%
87	1	< 0.1%
81	1	< 0.1%
80	1	< 0.1%
79	2	< 0.1%
78	1	< 0.1%
77	1	< 0.1%
76	2	< 0.1%
75	2	< 0.1%
74	1	< 0.1%

initial_list_status
Boolean

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	38.9 KiB

False	39717

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	39717	100.0%

out_prncp
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	1137
Distinct (%)	2.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	51.227887

Minimum	0
Maximum	6311.47
Zeros	38577
Zeros (%)	97.1%
Negative	0
Negative (%)	0.0%
Memory size	310.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	6311.47
Range	6311.47
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	375.17284
Coefficient of variation (CV)	7.3236055
Kurtosis	97.658555
Mean	51.227887
Median Absolute Deviation (MAD)	0
Skewness	9.22673
Sum	2034618
Variance	140754.66
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	38577	97.1%
1972.6	2	< 0.1%
827.13	2	< 0.1%
2277.11	2	< 0.1%
2963.24	2	< 0.1%
2000.47	1	< 0.1%
241.36	1	< 0.1%
581.29	1	< 0.1%
992.48	1	< 0.1%
1279.63	1	< 0.1%
Other values (1127)	1127	2.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	38577	97.1%
10.26	1	< 0.1%
11.91	1	< 0.1%
13.28	1	< 0.1%
19.12	1	< 0.1%
27.41	1	< 0.1%
40.65	1	< 0.1%
50.46	1	< 0.1%
53	1	< 0.1%
57.67	1	< 0.1%

Value	Count	Frequency (%)
6311.47	1	< 0.1%
6308.37	1	< 0.1%
6307.37	1	< 0.1%
6307.15	1	< 0.1%
6219.16	1	< 0.1%
6219.11	1	< 0.1%
6182.86	1	< 0.1%
6071.68	1	< 0.1%
6034.37	1	< 0.1%
6027.7	1	< 0.1%

out_prncp_inv
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	1138
Distinct (%)	2.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	50.989768

Minimum	0
Maximum	6307.37
Zeros	38577
Zeros (%)	97.1%
Negative	0
Negative (%)	0.0%
Memory size	310.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	6307.37
Range	6307.37
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	373.82446
Coefficient of variation (CV)	7.3313622
Kurtosis	98.040553
Mean	50.989768
Median Absolute Deviation (MAD)	0
Skewness	9.2437655
Sum	2025160.6
Variance	139744.72
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	38577	97.1%
1972.6	2	< 0.1%
1664.64	2	< 0.1%
827.13	2	< 0.1%
1863.21	1	< 0.1%
2398.86	1	< 0.1%
285.12	1	< 0.1%
804.39	1	< 0.1%
1588.87	1	< 0.1%
1054.65	1	< 0.1%
Other values (1128)	1128	2.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	38577	97.1%
10.26	1	< 0.1%
11.91	1	< 0.1%
13.28	1	< 0.1%
19.09	1	< 0.1%
27.41	1	< 0.1%
40.65	1	< 0.1%
50.46	1	< 0.1%
53	1	< 0.1%
57.67	1	< 0.1%

Value	Count	Frequency (%)
6307.37	1	< 0.1%
6306.96	1	< 0.1%
6298.11	1	< 0.1%
6276.75	1	< 0.1%
6219.16	1	< 0.1%
6183.55	1	< 0.1%
6182.86	1	< 0.1%
6067.33	1	< 0.1%
6034.37	1	< 0.1%
6027.7	1	< 0.1%

total_pymnt
Real number (ℝ)

HIGH CORRELATION

Distinct	37850
Distinct (%)	95.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12153.597

Minimum	0
Maximum	58563.68
Zeros	16
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	310.4 KiB

Quantile statistics

Minimum	0
5-th percentile	1887.957
Q1	5576.93
median	9899.6403
Q3	16534.433
95-th percentile	30245.119
Maximum	58563.68
Range	58563.68
Interquartile range (IQR)	10957.503

Descriptive statistics

Standard deviation	9042.0408
Coefficient of variation (CV)	0.74398066
Kurtosis	1.9858942
Mean	12153.597
Median Absolute Deviation (MAD)	5016.7567
Skewness	1.3398574
Sum	4.8270439 × 10⁸
Variance	81758501
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11196.56943	26	0.1%
0	16	< 0.1%
11784.23223	16	< 0.1%
10956.77596	16	< 0.1%
5478.387981	15	< 0.1%
13148.13786	15	< 0.1%
13435.90021	13	< 0.1%
5557.025543	13	< 0.1%
13263.95464	12	< 0.1%
8760.210626	11	< 0.1%
Other values (37840)	39564	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	16	< 0.1%
33.73	1	< 0.1%
35.71	1	< 0.1%
44.92	2	< 0.1%
44.96	1	< 0.1%
61.71	1	< 0.1%
62.86	1	< 0.1%
66.77	1	< 0.1%
67.32	1	< 0.1%
69.64	1	< 0.1%

Value	Count	Frequency (%)
58563.67993	1	< 0.1%
58480.13992	1	< 0.1%
57835.27991	1	< 0.1%
56849.26986	1	< 0.1%
56662.58994	1	< 0.1%
56199.43995	1	< 0.1%
55906.9499	1	< 0.1%
55768.77995	1	< 0.1%
55368.40995	1	< 0.1%
55138.99996	1	< 0.1%

total_pymnt_inv
Real number (ℝ)

HIGH CORRELATION

Distinct	37518
Distinct (%)	94.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11567.149

Minimum	0
Maximum	58563.68
Zeros	165
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	310.4 KiB

Quantile statistics

Minimum	0
5-th percentile	1420.408
Q1	5112.31
median	9287.15
Q3	15798.81
95-th percentile	29627.236
Maximum	58563.68
Range	58563.68
Interquartile range (IQR)	10686.5

Descriptive statistics

Standard deviation	8942.6726
Coefficient of variation (CV)	0.77310948
Kurtosis	2.0297585
Mean	11567.149
Median Absolute Deviation (MAD)	4939.58
Skewness	1.3548376
Sum	4.5941246 × 10⁸
Variance	79971393
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	165	0.4%
6514.52	16	< 0.1%
5478.39	14	< 0.1%
13148.14	14	< 0.1%
11196.57	12	< 0.1%
10956.78	12	< 0.1%
6717.95	12	< 0.1%
5557.03	11	< 0.1%
7328.92	11	< 0.1%
13517.36	11	< 0.1%
Other values (37508)	39439	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	165	0.4%
0.54	1	< 0.1%
12.65	1	< 0.1%
18.97	1	< 0.1%
21.6	1	< 0.1%
25.18	1	< 0.1%
26.19	1	< 0.1%
33.73	1	< 0.1%
33.99	1	< 0.1%
35.71	1	< 0.1%

Value	Count	Frequency (%)
58563.68	1	< 0.1%
58438.37	1	< 0.1%
57628.73	1	< 0.1%
56622.12	1	< 0.1%
56515.16	1	< 0.1%
55867.02	1	< 0.1%
55579.28	1	< 0.1%
55066.92	1	< 0.1%
54675.68	1	< 0.1%
54315.94	1	< 0.1%

total_rec_prncp
Real number (ℝ)

HIGH CORRELATION

Distinct	7976
Distinct (%)	20.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9793.3488

Minimum	0
Maximum	35000.02
Zeros	74
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	310.4 KiB

Quantile statistics

Minimum	0
5-th percentile	1339.842
Q1	4600
median	8000
Q3	13653.26
95-th percentile	24999.982
Maximum	35000.02
Range	35000.02
Interquartile range (IQR)	9053.26

Descriptive statistics

Standard deviation	7065.5221
Coefficient of variation (CV)	0.7214613
Kurtosis	1.1033555
Mean	9793.3488
Median Absolute Deviation (MAD)	4000
Skewness	1.1182545
Sum	3.8896243 × 10⁸
Variance	49921603
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10000	2293	5.8%
12000	1805	4.5%
5000	1702	4.3%
6000	1637	4.1%
15000	1400	3.5%
8000	1318	3.3%
20000	1059	2.7%
4000	956	2.4%
3000	883	2.2%
7000	851	2.1%
Other values (7966)	25813	65.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	74	0.2%
21.21	1	< 0.1%
21.93	1	< 0.1%
22.24	1	< 0.1%
22.5	1	< 0.1%
24.87	1	< 0.1%
30.32	1	< 0.1%
32.51	1	< 0.1%
34.5	1	< 0.1%
35.14	1	< 0.1%

Value	Count	Frequency (%)
35000.02	2	< 0.1%
35000.01	1	< 0.1%
35000	363	0.9%
34999.99	5	< 0.1%
34999.98	1	< 0.1%
34999.97	1	< 0.1%
34911.47	1	< 0.1%
34800	1	< 0.1%
34793.43	1	< 0.1%
34675	1	< 0.1%

total_rec_int
Real number (ℝ)

HIGH CORRELATION

Distinct	35148
Distinct (%)	88.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2263.6632

Minimum	0
Maximum	23563.68
Zeros	71
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	310.4 KiB

Quantile statistics

Minimum	0
5-th percentile	186.168
Q1	662.18
median	1348.91
Q3	2833.4
95-th percentile	7575.812
Maximum	23563.68
Range	23563.68
Interquartile range (IQR)	2171.22

Descriptive statistics

Standard deviation	2608.112
Coefficient of variation (CV)	1.1521643
Kurtosis	9.6882784
Mean	2263.6632
Median Absolute Deviation (MAD)	866.01
Skewness	2.6687472
Sum	89905910
Variance	6802248
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	71	0.2%
1196.57	26	0.1%
514.52	19	< 0.1%
956.78	17	< 0.1%
1784.23	17	< 0.1%
1148.14	17	< 0.1%
717.95	17	< 0.1%
478.39	16	< 0.1%
1907.35	14	< 0.1%
1435.9	13	< 0.1%
Other values (35138)	39490	99.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	71	0.2%
6.22	1	< 0.1%
6.27	1	< 0.1%
7.19	1	< 0.1%
7.2	2	< 0.1%
8.23	1	< 0.1%
9.34	1	< 0.1%
9.49	1	< 0.1%
9.58	2	< 0.1%
10.26	1	< 0.1%

Value	Count	Frequency (%)
23563.68	1	< 0.1%
23506.56	1	< 0.1%
23480.14	1	< 0.1%
22835.28	1	< 0.1%
22716.42	1	< 0.1%
22594.16	1	< 0.1%
22593.34	1	< 0.1%
22593.04	1	< 0.1%
22587.51	1	< 0.1%
22422.33	1	< 0.1%

total_rec_late_fee
Real number (ℝ)

ZEROS

Distinct	1356
Distinct (%)	3.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.3630152

Minimum	0
Maximum	180.2
Zeros	37671
Zeros (%)	94.8%
Negative	0
Negative (%)	0.0%
Memory size	310.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	14.924199
Maximum	180.2
Range	180.2
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	7.2899793
Coefficient of variation (CV)	5.3484211
Kurtosis	100.85154
Mean	1.3630152
Median Absolute Deviation (MAD)	0
Skewness	8.429536
Sum	54134.875
Variance	53.143798
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	37671	94.8%
15	255	0.6%
15.00000001	58	0.1%
30	55	0.1%
15.00000002	47	0.1%
14.99999999	40	0.1%
14.99999998	33	0.1%
15.00000003	32	0.1%
14.99999997	25	0.1%
15.00000004	25	0.1%
Other values (1346)	1476	3.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	37671	94.8%
0.01	1	< 0.1%
0.060799751	1	< 0.1%
0.073787104	1	< 0.1%
0.101704562	1	< 0.1%
0.139999999	1	< 0.1%
0.180082904	1	< 0.1%
0.18477362	1	< 0.1%
0.27	1	< 0.1%
0.302036553	1	< 0.1%

Value	Count	Frequency (%)
180.2	1	< 0.1%
166.4297107	1	< 0.1%
165.69	1	< 0.1%
146.6000003	1	< 0.1%
146.04	1	< 0.1%
134.0700007	1	< 0.1%
130.5970372	1	< 0.1%
130.47	1	< 0.1%
127.7878136	1	< 0.1%
121.93	1	< 0.1%

recoveries
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	4040
Distinct (%)	10.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	95.221624

Minimum	0
Maximum	29623.35
Zeros	35499
Zeros (%)	89.4%
Negative	0
Negative (%)	0.0%
Memory size	310.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	362.418
Maximum	29623.35
Range	29623.35
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	688.74477
Coefficient of variation (CV)	7.233071
Kurtosis	379.37758
Mean	95.221624
Median Absolute Deviation (MAD)	0
Skewness	16.519378
Sum	3781917.2
Variance	474369.36
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	35499	89.4%
11.29	4	< 0.1%
10.4	4	< 0.1%
10.66	3	< 0.1%
44.92	3	< 0.1%
10.07	3	< 0.1%
16.27	3	< 0.1%
13	3	< 0.1%
164.81	3	< 0.1%
16.5	3	< 0.1%
Other values (4030)	4189	10.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	35499	89.4%
6.3	1	< 0.1%
6.31	1	< 0.1%
8.19	1	< 0.1%
8.36	1	< 0.1%
8.41	1	< 0.1%
8.46	1	< 0.1%
8.56	1	< 0.1%
8.71	1	< 0.1%
8.88	1	< 0.1%

Value	Count	Frequency (%)
29623.35	1	< 0.1%
22943.37	1	< 0.1%
21810.31	1	< 0.1%
20006.53	1	< 0.1%
19915.67	1	< 0.1%
19508.26	1	< 0.1%
18694.32	1	< 0.1%
16560.06	1	< 0.1%
16502.69	1	< 0.1%
16268.35	1	< 0.1%

collection_recovery_fee
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	2616
Distinct (%)	6.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.406112

Minimum	0
Maximum	7002.19
Zeros	35935
Zeros (%)	90.5%
Negative	0
Negative (%)	0.0%
Memory size	310.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	5.152
Maximum	7002.19
Range	7002.19
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	148.67159
Coefficient of variation (CV)	11.983738
Kurtosis	821.30066
Mean	12.406112
Median Absolute Deviation (MAD)	0
Skewness	25.029418
Sum	492733.55
Variance	22103.243
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	35935	90.5%
2	12	< 0.1%
1.2	10	< 0.1%
3.71	9	< 0.1%
1.88	8	< 0.1%
1.21	8	< 0.1%
0.8	8	< 0.1%
2.02	8	< 0.1%
1.69	8	< 0.1%
1.6	8	< 0.1%
Other values (2606)	3703	9.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	35935	90.5%
0.063	1	< 0.1%
0.074500001	1	< 0.1%
0.134799995	1	< 0.1%
0.1393	1	< 0.1%
0.16	1	< 0.1%
0.1952	1	< 0.1%
0.197899999	1	< 0.1%
0.200700001	1	< 0.1%
0.2147	1	< 0.1%

Value	Count	Frequency (%)
7002.19	1	< 0.1%
6972.59	1	< 0.1%
6543.04	1	< 0.1%
5774.8	1	< 0.1%
5602.72	1	< 0.1%
5569.92	1	< 0.1%
5216.74	1	< 0.1%
5036.01	1	< 0.1%
4902.08	1	< 0.1%
4900.75	1	< 0.1%

last_pymnt_d
Text

Distinct	101
Distinct (%)	0.3%
Missing	71
Missing (%)	0.2%
Memory size	310.4 KiB

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	237876
Distinct characters	32
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Jan-15
2nd row	Apr-13
3rd row	Jun-14
4th row	Jan-15
5th row	May-16

Value	Count	Frequency (%)
may-16	1256	3.2%
mar-13	1026	2.6%
dec-14	945	2.4%
may-13	907	2.3%
feb-13	869	2.2%
apr-13	851	2.1%
mar-12	844	2.1%
jan-14	832	2.1%
aug-14	832	2.1%
aug-12	832	2.1%
Other values (91)	30452	76.8%

Most occurring characters

Value	Count	Frequency (%)
1	43946	18.5%
-	39646	16.7%
a	11087	4.7%
e	9738	4.1%
3	9458	4.0%
u	9401	4.0%
4	9269	3.9%
J	9200	3.9%
2	8904	3.7%
M	8046	3.4%
Other values (22)	79181	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	79292	33.3%
Lowercase Letter	79292	33.3%
Dash Punctuation	39646	16.7%
Uppercase Letter	39646	16.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	11087	14.0%
e	9738	12.3%
u	9401	11.9%
r	6965	8.8%
c	6783	8.6%
p	6219	7.8%
n	5974	7.5%
y	4285	5.4%
t	3271	4.1%
g	3242	4.1%
Other values (4)	12327	15.5%

Decimal Number

Value	Count	Frequency (%)
1	43946	55.4%
3	9458	11.9%
4	9269	11.7%
2	8904	11.2%
0	2544	3.2%
5	2431	3.1%
6	2044	2.6%
9	559	0.7%
8	137	0.2%

Uppercase Letter

Value	Count	Frequency (%)
J	9200	23.2%
M	8046	20.3%
A	6446	16.3%
D	3512	8.9%
O	3271	8.3%
F	3211	8.1%
S	3015	7.6%
N	2945	7.4%

Dash Punctuation

Value	Count	Frequency (%)
-	39646	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	118938	50.0%
Latin	118938	50.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	11087	9.3%
e	9738	8.2%
u	9401	7.9%
J	9200	7.7%
M	8046	6.8%
r	6965	5.9%
c	6783	5.7%
A	6446	5.4%
p	6219	5.2%
n	5974	5.0%
Other values (12)	39079	32.9%

Common

Value	Count	Frequency (%)
1	43946	36.9%
-	39646	33.3%
3	9458	8.0%
4	9269	7.8%
2	8904	7.5%
0	2544	2.1%
5	2431	2.0%
6	2044	1.7%
9	559	0.5%
8	137	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	237876	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	43946	18.5%
-	39646	16.7%
a	11087	4.7%
e	9738	4.1%
3	9458	4.0%
u	9401	4.0%
4	9269	3.9%
J	9200	3.9%
2	8904	3.7%
M	8046	3.4%
Other values (22)	79181	33.3%

last_pymnt_amnt
Real number (ℝ)

HIGH CORRELATION

Distinct	34930
Distinct (%)	87.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2678.8262

Minimum	0
Maximum	36115.2
Zeros	74
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	310.4 KiB

Quantile statistics

Minimum	0
5-th percentile	43.34
Q1	218.68
median	546.14
Q3	3293.16
95-th percentile	12183.944
Maximum	36115.2
Range	36115.2
Interquartile range (IQR)	3074.48

Descriptive statistics

Standard deviation	4447.136
Coefficient of variation (CV)	1.6601062
Kurtosis	8.8678197
Mean	2678.8262
Median Absolute Deviation (MAD)	449.45
Skewness	2.7121222
Sum	1.0639494 × 10⁸
Variance	19777019
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	74	0.2%
276.06	21	0.1%
200	17	< 0.1%
50	16	< 0.1%
100	15	< 0.1%
400	12	< 0.1%
773.44	12	< 0.1%
150	11	< 0.1%
786.01	11	< 0.1%
500	11	< 0.1%
Other values (34920)	39517	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	74	0.2%
0.01	1	< 0.1%
0.02	1	< 0.1%
0.03	1	< 0.1%
0.13	1	< 0.1%
0.16	1	< 0.1%
0.2	1	< 0.1%
0.24	1	< 0.1%
0.25	1	< 0.1%
0.28	1	< 0.1%

Value	Count	Frequency (%)
36115.2	1	< 0.1%
35613.68	1	< 0.1%
35596.41	1	< 0.1%
35479.89	1	< 0.1%
35471.86	1	< 0.1%
35395.59	1	< 0.1%
35339.05	1	< 0.1%
35337.09	1	< 0.1%
35322.96	1	< 0.1%
35322.6	1	< 0.1%

next_pymnt_d
Categorical

HIGH CORRELATION IMBALANCE MISSING

Distinct	2
Distinct (%)	0.2%
Missing	38577
Missing (%)	97.1%
Memory size	310.4 KiB

Jun-16	1125
Jul-16	15

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	6840
Distinct characters	7
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Jun-16
2nd row	Jun-16
3rd row	Jun-16
4th row	Jun-16
5th row	Jun-16

Common Values

Value	Count	Frequency (%)
Jun-16	1125	2.8%
Jul-16	15	< 0.1%
(Missing)	38577	97.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
jun-16	1125	98.7%
jul-16	15	1.3%

Most occurring characters

Value	Count	Frequency (%)
J	1140	16.7%
u	1140	16.7%
-	1140	16.7%
1	1140	16.7%
6	1140	16.7%
n	1125	16.4%
l	15	0.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2280	33.3%
Decimal Number	2280	33.3%
Uppercase Letter	1140	16.7%
Dash Punctuation	1140	16.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
u	1140	50.0%
n	1125	49.3%
l	15	0.7%

Decimal Number

Value	Count	Frequency (%)
1	1140	50.0%
6	1140	50.0%

Uppercase Letter

Value	Count	Frequency (%)
J	1140	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1140	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3420	50.0%
Common	3420	50.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
J	1140	33.3%
u	1140	33.3%
n	1125	32.9%
l	15	0.4%

Common

Value	Count	Frequency (%)
-	1140	33.3%
1	1140	33.3%
6	1140	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6840	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
J	1140	16.7%
u	1140	16.7%
-	1140	16.7%
1	1140	16.7%
6	1140	16.7%
n	1125	16.4%
l	15	0.2%

last_credit_pull_d
Text

Distinct	106
Distinct (%)	0.3%
Missing	2
Missing (%)	< 0.1%
Memory size	310.4 KiB

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	238290
Distinct characters	33
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	< 0.1%

Sample

1st row	May-16
2nd row	Sep-13
3rd row	May-16
4th row	Apr-16
5th row	May-16

Value	Count	Frequency (%)
may-16	10308	26.0%
apr-16	2547	6.4%
mar-16	1123	2.8%
feb-13	843	2.1%
feb-16	736	1.9%
jan-16	657	1.7%
dec-15	647	1.6%
mar-13	577	1.5%
mar-14	564	1.4%
dec-14	562	1.4%
Other values (96)	21151	53.3%

Most occurring characters

Value	Count	Frequency (%)
1	41601	17.5%
-	39715	16.7%
a	17601	7.4%
M	15523	6.5%
6	15371	6.5%
y	12231	5.1%
r	7664	3.2%
e	7600	3.2%
p	6483	2.7%
A	6411	2.7%
Other values (23)	68090	28.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	79430	33.3%
Lowercase Letter	79430	33.3%
Dash Punctuation	39715	16.7%
Uppercase Letter	39715	16.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	17601	22.2%
y	12231	15.4%
r	7664	9.6%
e	7600	9.6%
p	6483	8.2%
u	5856	7.4%
c	4475	5.6%
n	3834	4.8%
b	3075	3.9%
o	2225	2.8%
Other values (4)	8386	10.6%

Decimal Number

Value	Count	Frequency (%)
1	41601	52.4%
6	15371	19.4%
4	6255	7.9%
5	5502	6.9%
3	5164	6.5%
2	4079	5.1%
0	1153	1.5%
9	228	0.3%
8	41	0.1%
7	36	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
M	15523	39.1%
A	6411	16.1%
J	5895	14.8%
F	3075	7.7%
D	2414	6.1%
N	2225	5.6%
S	2111	5.3%
O	2061	5.2%

Dash Punctuation

Value	Count	Frequency (%)
-	39715	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	119145	50.0%
Latin	119145	50.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	17601	14.8%
M	15523	13.0%
y	12231	10.3%
r	7664	6.4%
e	7600	6.4%
p	6483	5.4%
A	6411	5.4%
J	5895	4.9%
u	5856	4.9%
c	4475	3.8%
Other values (12)	29406	24.7%

Common

Value	Count	Frequency (%)
1	41601	34.9%
-	39715	33.3%
6	15371	12.9%
4	6255	5.2%
5	5502	4.6%
3	5164	4.3%
2	4079	3.4%
0	1153	1.0%
9	228	0.2%
8	41	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	238290	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	41601	17.5%
-	39715	16.7%
a	17601	7.4%
M	15523	6.5%
6	15371	6.5%
y	12231	5.1%
r	7664	3.2%
e	7600	3.2%
p	6483	2.7%
A	6411	2.7%
Other values (23)	68090	28.6%

collections_12_mths_ex_med
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	56
Missing (%)	0.1%
Memory size	310.4 KiB

0.0	39661

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	118983
Distinct characters	2
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	39661	99.9%
(Missing)	56	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	39661	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	79322	66.7%
.	39661	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	79322	66.7%
Other Punctuation	39661	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	79322	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	39661	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	118983	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	79322	66.7%
.	39661	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	118983	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	79322	66.7%
.	39661	33.3%

mths_since_last_major_derog
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

policy_code
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

1	39717

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	39717
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	39717	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	39717	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	39717	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	39717	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	39717	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	39717	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	39717	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	39717	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	39717	100.0%

application_type
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

INDIVIDUAL	39717

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	397170
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	INDIVIDUAL
2nd row	INDIVIDUAL
3rd row	INDIVIDUAL
4th row	INDIVIDUAL
5th row	INDIVIDUAL

Common Values

Value	Count	Frequency (%)
INDIVIDUAL	39717	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
individual	39717	100.0%

Most occurring characters

Value	Count	Frequency (%)
I	119151	30.0%
D	79434	20.0%
N	39717	10.0%
V	39717	10.0%
U	39717	10.0%
A	39717	10.0%
L	39717	10.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	397170	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	119151	30.0%
D	79434	20.0%
N	39717	10.0%
V	39717	10.0%
U	39717	10.0%
A	39717	10.0%
L	39717	10.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	397170	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	119151	30.0%
D	79434	20.0%
N	39717	10.0%
V	39717	10.0%
U	39717	10.0%
A	39717	10.0%
L	39717	10.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	397170	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
I	119151	30.0%
D	79434	20.0%
N	39717	10.0%
V	39717	10.0%
U	39717	10.0%
A	39717	10.0%
L	39717	10.0%

annual_inc_joint
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

dti_joint
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

verification_status_joint
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

acc_now_delinq
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

0	39717

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	39717
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	39717	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	39717	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	39717	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	39717	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	39717	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	39717	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	39717	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	39717	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	39717	100.0%

tot_coll_amt
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

tot_cur_bal
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

open_acc_6m
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

open_il_6m
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

open_il_12m
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

open_il_24m
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

mths_since_rcnt_il
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

total_bal_il
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

il_util
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

open_rv_12m
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

open_rv_24m
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

max_bal_bc
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

all_util
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

total_rev_hi_lim
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

inq_fi
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

total_cu_tl
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

inq_last_12m
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

acc_open_past_24mths
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

avg_cur_bal
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

bc_open_to_buy
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

bc_util
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

chargeoff_within_12_mths
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	56
Missing (%)	0.1%
Memory size	310.4 KiB

0.0	39661

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	118983
Distinct characters	2
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	39661	99.9%
(Missing)	56	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	39661	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	79322	66.7%
.	39661	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	79322	66.7%
Other Punctuation	39661	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	79322	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	39661	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	118983	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	79322	66.7%
.	39661	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	118983	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	79322	66.7%
.	39661	33.3%

delinq_amnt
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

0	39717

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	39717
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	39717	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	39717	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	39717	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	39717	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	39717	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	39717	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	39717	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	39717	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	39717	100.0%

mo_sin_old_il_acct
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

mo_sin_old_rev_tl_op
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

mo_sin_rcnt_rev_tl_op
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

mo_sin_rcnt_tl
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

mort_acc
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

mths_since_recent_bc
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

mths_since_recent_bc_dlq
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

mths_since_recent_inq
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

mths_since_recent_revol_delinq
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

num_accts_ever_120_pd
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

num_actv_bc_tl
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

num_actv_rev_tl
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

num_bc_sats
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

num_bc_tl
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

num_il_tl
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

num_op_rev_tl
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

num_rev_accts
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

num_rev_tl_bal_gt_0
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

num_sats
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

num_tl_120dpd_2m
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

num_tl_30dpd
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

num_tl_90g_dpd_24m
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

num_tl_op_past_12m
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

pct_tl_nvr_dlq
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

percent_bc_gt_75
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

pub_rec_bankruptcies
Categorical

HIGH CORRELATION IMBALANCE MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	697
Missing (%)	1.8%
Memory size	310.4 KiB

0.0	37339
1.0	1674
2.0	7

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	117060
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	37339	94.0%
1.0	1674	4.2%
2.0	7	< 0.1%
(Missing)	697	1.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	37339	95.7%
1.0	1674	4.3%
2.0	7	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	76359	65.2%
.	39020	33.3%
1	1674	1.4%
2	7	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	78040	66.7%
Other Punctuation	39020	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	76359	97.8%
1	1674	2.1%
2	7	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
.	39020	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	117060	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	76359	65.2%
.	39020	33.3%
1	1674	1.4%
2	7	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	117060	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	76359	65.2%
.	39020	33.3%
1	1674	1.4%
2	7	< 0.1%

tax_liens
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	39
Missing (%)	0.1%
Memory size	310.4 KiB

0.0	39678

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	119034
Distinct characters	2
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	39678	99.9%
(Missing)	39	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	39678	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	79356	66.7%
.	39678	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	79356	66.7%
Other Punctuation	39678	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	79356	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	39678	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	119034	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	79356	66.7%
.	39678	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	119034	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	79356	66.7%
.	39678	33.3%

tot_hi_cred_lim
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

total_bal_ex_mort
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

total_bc_limit
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

total_il_high_credit_limit
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

Auto

Heatmap
Table

	id	member_id	loan_amnt	funded_amnt	funded_amnt_inv	installment	annual_inc	dti	delinq_2yrs	inq_last_6mths	mths_since_last_delinq	mths_since_last_record	open_acc	revol_bal	total_acc	out_prncp	out_prncp_inv	total_pymnt	total_pymnt_inv	total_rec_prncp	total_rec_int	total_rec_late_fee	recoveries	collection_recovery_fee	last_pymnt_amnt	term	grade	sub_grade	emp_length	home_ownership	verification_status	loan_status	purpose	addr_state	pub_rec	next_pymnt_d	pub_rec_bankruptcies
id	1.000	0.999	0.111	0.121	0.233	0.076	0.044	0.087	-0.010	-0.038	0.094	0.593	0.031	0.049	0.052	0.188	0.188	0.103	0.201	0.082	0.106	-0.052	0.052	0.038	0.121	0.299	0.049	0.068	0.056	0.083	0.236	0.148	0.073	0.091	0.017	0.012	0.071
member_id	0.999	1.000	0.110	0.121	0.232	0.075	0.043	0.088	-0.009	-0.038	0.094	0.594	0.031	0.049	0.052	0.187	0.187	0.103	0.200	0.081	0.105	-0.052	0.052	0.038	0.121	0.311	0.051	0.070	0.056	0.082	0.253	0.153	0.074	0.099	0.019	0.025	0.044
loan_amnt	0.111	0.110	1.000	0.991	0.935	0.958	0.429	0.074	-0.037	-0.003	0.022	0.022	0.208	0.399	0.275	0.123	0.123	0.887	0.838	0.837	0.778	-0.021	0.044	0.034	0.449	0.364	0.137	0.125	0.054	0.088	0.313	0.108	0.116	0.019	0.023	0.000	0.028
funded_amnt	0.121	0.121	0.991	1.000	0.946	0.972	0.425	0.074	-0.037	-0.004	0.023	0.017	0.206	0.395	0.270	0.124	0.124	0.896	0.849	0.846	0.785	-0.021	0.044	0.034	0.453	0.344	0.137	0.123	0.054	0.085	0.306	0.106	0.115	0.016	0.023	0.055	0.027
funded_amnt_inv	0.233	0.232	0.935	0.946	1.000	0.910	0.402	0.083	-0.042	-0.017	0.095	0.456	0.192	0.369	0.262	0.133	0.133	0.860	0.906	0.812	0.757	-0.036	0.036	0.024	0.444	0.367	0.131	0.117	0.058	0.084	0.314	0.109	0.109	0.026	0.024	0.056	0.030
installment	0.076	0.075	0.958	0.972	0.910	1.000	0.422	0.067	-0.023	0.000	0.010	-0.020	0.197	0.395	0.247	0.070	0.070	0.871	0.817	0.835	0.734	-0.017	0.026	0.021	0.439	0.148	0.137	0.123	0.045	0.070	0.272	0.060	0.113	0.015	0.022	0.000	0.028
annual_inc	0.044	0.043	0.429	0.425	0.402	0.422	1.000	-0.103	0.036	0.033	-0.006	0.033	0.305	0.397	0.430	0.038	0.038	0.406	0.386	0.400	0.304	-0.033	-0.056	-0.057	0.245	0.000	0.000	0.000	0.006	0.000	0.000	0.000	0.000	0.016	0.000	0.000	0.000
dti	0.087	0.088	0.074	0.074	0.083	0.067	-0.103	1.000	-0.038	0.013	0.065	0.171	0.305	0.332	0.240	0.035	0.035	0.064	0.071	0.042	0.120	-0.007	0.028	0.021	0.013	0.083	0.063	0.057	0.019	0.024	0.073	0.046	0.082	0.032	0.015	0.000	0.015
delinq_2yrs	-0.010	-0.009	-0.037	-0.037	-0.042	-0.023	0.036	-0.038	1.000	0.011	-0.722	-0.042	0.006	-0.083	0.071	-0.002	-0.002	-0.029	-0.036	-0.042	0.019	0.042	0.018	0.020	-0.022	0.005	0.050	0.046	0.000	0.004	0.000	0.007	0.020	0.000	0.035	0.000	0.014
inq_last_6mths	-0.038	-0.038	-0.003	-0.004	-0.017	0.000	0.033	0.013	0.011	1.000	0.003	-0.023	0.094	-0.026	0.104	-0.013	-0.013	-0.027	-0.037	-0.042	0.020	0.032	0.050	0.044	0.009	0.042	0.079	0.085	0.001	0.041	0.011	0.053	0.039	0.053	0.022	0.000	0.024
mths_since_last_delinq	0.094	0.094	0.022	0.023	0.095	0.010	-0.006	0.065	-0.722	0.003	1.000	0.514	0.032	0.078	0.012	0.004	0.004	0.019	0.086	0.021	0.012	-0.037	0.007	0.002	0.026	0.041	0.038	0.034	0.032	0.025	0.055	0.025	0.004	0.043	0.031	0.000	0.017
mths_since_last_record	0.593	0.594	0.022	0.017	0.456	-0.020	0.033	0.171	-0.042	-0.023	0.514	1.000	0.054	0.029	0.117	0.072	0.072	-0.007	0.396	-0.035	0.063	-0.066	0.032	0.009	0.082	0.298	0.085	0.095	0.093	0.066	0.338	0.062	0.062	0.099	0.526	1.000	0.658
open_acc	0.031	0.031	0.208	0.206	0.192	0.197	0.305	0.305	0.006	0.094	0.032	0.054	1.000	0.390	0.689	0.029	0.029	0.187	0.175	0.183	0.147	-0.039	-0.023	-0.031	0.099	0.054	0.076	0.085	0.033	0.106	0.072	0.019	0.048	0.026	0.000	0.062	0.000
revol_bal	0.049	0.049	0.399	0.395	0.369	0.395	0.397	0.332	-0.083	-0.026	0.078	0.029	0.390	1.000	0.379	0.053	0.053	0.360	0.337	0.335	0.342	-0.033	-0.001	-0.009	0.161	0.096	0.049	0.046	0.055	0.109	0.133	0.037	0.063	0.015	0.034	0.000	0.042
total_acc	0.052	0.052	0.275	0.270	0.262	0.247	0.430	0.240	0.071	0.104	0.012	0.117	0.689	0.379	1.000	0.026	0.026	0.241	0.235	0.242	0.154	-0.048	-0.044	-0.055	0.178	0.100	0.050	0.050	0.074	0.169	0.101	0.032	0.048	0.035	0.022	0.000	0.029
out_prncp	0.188	0.187	0.123	0.124	0.133	0.070	0.038	0.035	-0.002	-0.013	0.004	0.072	0.029	0.053	0.026	1.000	1.000	0.158	0.164	0.123	0.223	-0.005	-0.059	-0.056	-0.073	0.248	0.051	0.056	0.018	0.018	0.074	0.616	0.013	0.000	0.011	0.000	0.060
out_prncp_inv	0.188	0.187	0.123	0.124	0.133	0.070	0.038	0.035	-0.002	-0.013	0.004	0.072	0.029	0.053	0.026	1.000	1.000	0.158	0.164	0.123	0.223	-0.005	-0.059	-0.056	-0.073	0.247	0.052	0.056	0.018	0.018	0.074	0.615	0.013	0.000	0.011	0.000	0.060
total_pymnt	0.103	0.103	0.887	0.896	0.860	0.871	0.406	0.064	-0.029	-0.027	0.019	-0.007	0.187	0.360	0.241	0.158	0.158	1.000	0.956	0.977	0.823	-0.054	-0.207	-0.197	0.496	0.335	0.151	0.134	0.047	0.077	0.283	0.238	0.100	0.014	0.025	0.122	0.035
total_pymnt_inv	0.201	0.200	0.838	0.849	0.906	0.817	0.386	0.071	-0.036	-0.037	0.086	0.396	0.175	0.337	0.235	0.164	0.164	0.956	1.000	0.933	0.790	-0.066	-0.203	-0.194	0.485	0.350	0.144	0.128	0.051	0.077	0.286	0.239	0.096	0.017	0.025	0.177	0.039
total_rec_prncp	0.082	0.081	0.837	0.846	0.812	0.835	0.400	0.042	-0.042	-0.042	0.021	-0.035	0.183	0.335	0.242	0.123	0.123	0.977	0.933	1.000	0.721	-0.085	-0.323	-0.308	0.537	0.252	0.109	0.099	0.045	0.080	0.270	0.329	0.100	0.019	0.032	0.098	0.038
total_rec_int	0.106	0.105	0.778	0.785	0.757	0.734	0.304	0.120	0.019	0.020	0.012	0.063	0.147	0.342	0.154	0.223	0.223	0.823	0.790	0.721	1.000	0.025	0.017	0.006	0.246	0.542	0.234	0.202	0.042	0.058	0.254	0.235	0.069	0.000	0.012	0.000	0.059
total_rec_late_fee	-0.052	-0.052	-0.021	-0.021	-0.036	-0.017	-0.033	-0.007	0.042	0.032	-0.037	-0.066	-0.039	-0.033	-0.048	-0.005	-0.005	-0.054	-0.066	-0.085	0.025	1.000	0.185	0.189	-0.121	0.024	0.047	0.049	0.000	0.019	0.020	0.102	0.016	0.042	0.000	0.000	0.000
recoveries	0.052	0.052	0.044	0.044	0.036	0.026	-0.056	0.028	0.018	0.050	0.007	0.032	-0.023	-0.001	-0.044	-0.059	-0.059	-0.207	-0.203	-0.323	0.017	0.185	1.000	0.950	-0.251	0.060	0.039	0.050	0.005	0.000	0.039	0.145	0.013	0.000	0.000	1.000	0.000
collection_recovery_fee	0.038	0.038	0.034	0.034	0.024	0.021	-0.057	0.021	0.020	0.044	0.002	0.009	-0.031	-0.009	-0.055	-0.056	-0.056	-0.197	-0.194	-0.308	0.006	0.189	0.950	1.000	-0.244	0.040	0.032	0.039	0.000	0.000	0.026	0.114	0.006	0.000	0.000	1.000	0.000
last_pymnt_amnt	0.121	0.121	0.449	0.453	0.444	0.439	0.245	0.013	-0.022	0.009	0.026	0.082	0.099	0.161	0.178	-0.073	-0.073	0.496	0.485	0.537	0.246	-0.121	-0.251	-0.244	1.000	0.238	0.073	0.068	0.029	0.052	0.149	0.175	0.044	0.000	0.007	1.000	0.009
term	0.299	0.311	0.364	0.344	0.367	0.148	0.000	0.083	0.005	0.042	0.041	0.298	0.054	0.096	0.100	0.248	0.247	0.335	0.350	0.252	0.542	0.024	0.060	0.040	0.238	1.000	0.443	0.478	0.115	0.110	0.259	0.329	0.115	0.051	0.009	1.000	0.010
grade	0.049	0.051	0.137	0.137	0.131	0.137	0.000	0.063	0.050	0.079	0.038	0.085	0.076	0.049	0.050	0.051	0.052	0.151	0.144	0.109	0.234	0.047	0.039	0.032	0.073	0.443	1.000	1.000	0.017	0.049	0.142	0.159	0.069	0.014	0.054	0.056	0.066
sub_grade	0.068	0.070	0.125	0.123	0.117	0.123	0.000	0.057	0.046	0.085	0.034	0.095	0.085	0.046	0.050	0.056	0.056	0.134	0.128	0.099	0.202	0.049	0.050	0.039	0.068	0.478	1.000	1.000	0.018	0.055	0.150	0.166	0.053	0.006	0.057	0.000	0.072
emp_length	0.056	0.056	0.054	0.054	0.058	0.045	0.006	0.019	0.000	0.001	0.032	0.093	0.033	0.055	0.074	0.018	0.018	0.047	0.051	0.045	0.042	0.000	0.005	0.000	0.029	0.115	0.017	0.018	1.000	0.132	0.084	0.041	0.036	0.023	0.033	0.000	0.042
home_ownership	0.083	0.082	0.088	0.085	0.084	0.070	0.000	0.024	0.004	0.041	0.025	0.066	0.106	0.109	0.169	0.018	0.018	0.077	0.077	0.080	0.058	0.019	0.000	0.000	0.052	0.110	0.049	0.055	0.132	1.000	0.076	0.032	0.125	0.134	0.011	0.000	0.021
verification_status	0.236	0.253	0.313	0.306	0.314	0.272	0.000	0.073	0.000	0.011	0.055	0.338	0.072	0.133	0.101	0.074	0.074	0.283	0.286	0.270	0.254	0.020	0.039	0.026	0.149	0.259	0.142	0.150	0.084	0.076	1.000	0.070	0.097	0.039	0.007	0.029	0.008
loan_status	0.148	0.153	0.108	0.106	0.109	0.060	0.000	0.046	0.007	0.053	0.025	0.062	0.019	0.037	0.032	0.616	0.615	0.238	0.239	0.329	0.235	0.102	0.145	0.114	0.175	0.329	0.159	0.166	0.041	0.032	0.070	1.000	0.073	0.041	0.038	1.000	0.036
purpose	0.073	0.074	0.116	0.115	0.109	0.113	0.000	0.082	0.020	0.039	0.004	0.062	0.048	0.063	0.048	0.013	0.013	0.100	0.096	0.100	0.069	0.016	0.013	0.006	0.044	0.115	0.069	0.053	0.036	0.125	0.097	0.073	1.000	0.032	0.016	0.000	0.023
addr_state	0.091	0.099	0.019	0.016	0.026	0.015	0.016	0.032	0.000	0.053	0.043	0.099	0.026	0.015	0.035	0.000	0.000	0.014	0.017	0.019	0.000	0.042	0.000	0.000	0.000	0.051	0.014	0.006	0.023	0.134	0.039	0.041	0.032	1.000	0.038	0.000	0.049
pub_rec	0.017	0.019	0.023	0.023	0.024	0.022	0.000	0.015	0.035	0.022	0.031	0.526	0.000	0.034	0.022	0.011	0.011	0.025	0.025	0.032	0.012	0.000	0.000	0.000	0.007	0.009	0.054	0.057	0.033	0.011	0.007	0.038	0.016	0.038	1.000	0.000	0.690
next_pymnt_d	0.012	0.025	0.000	0.055	0.056	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.062	0.000	0.000	0.000	0.000	0.122	0.177	0.098	0.000	0.000	1.000	1.000	1.000	1.000	0.056	0.000	0.000	0.000	0.029	1.000	0.000	0.000	0.000	1.000	0.000
pub_rec_bankruptcies	0.071	0.044	0.028	0.027	0.030	0.028	0.000	0.015	0.014	0.024	0.017	0.658	0.000	0.042	0.029	0.060	0.060	0.035	0.039	0.038	0.059	0.000	0.000	0.000	0.009	0.010	0.066	0.072	0.042	0.021	0.008	0.036	0.023	0.049	0.690	0.000	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	id	member_id	loan_amnt	funded_amnt	funded_amnt_inv	term	int_rate	installment	grade	sub_grade	emp_title	emp_length	home_ownership	annual_inc	verification_status	issue_d	loan_status	pymnt_plan	url	desc	purpose	title	zip_code	addr_state	dti	earliest_cr_line	inq_last_6mths	mths_since_last_delinq	mths_since_last_record	open_acc	revol_bal	revol_util	total_acc	initial_list_status	out_prncp	out_prncp_inv	total_pymnt	total_pymnt_inv	total_rec_prncp	total_rec_int	total_rec_late_fee	recoveries	collection_recovery_fee	last_pymnt_d	last_pymnt_amnt	next_pymnt_d	last_credit_pull_d	mths_since_last_major_derog	policy_code	application_type	annual_inc_joint	dti_joint	verification_status_joint	tot_coll_amt	tot_cur_bal	open_acc_6m	open_il_6m	open_il_12m	open_il_24m	mths_since_rcnt_il	total_bal_il	il_util	open_rv_12m	open_rv_24m	max_bal_bc	all_util	total_rev_hi_lim	inq_fi	total_cu_tl	inq_last_12m	acc_open_past_24mths	avg_cur_bal	bc_open_to_buy	bc_util	mo_sin_old_il_acct	mo_sin_old_rev_tl_op	mo_sin_rcnt_rev_tl_op	mo_sin_rcnt_tl	mort_acc	mths_since_recent_bc	mths_since_recent_bc_dlq	mths_since_recent_inq	mths_since_recent_revol_delinq	num_accts_ever_120_pd	num_actv_bc_tl	num_actv_rev_tl	num_bc_sats	num_bc_tl	num_il_tl	num_op_rev_tl	num_rev_accts	num_rev_tl_bal_gt_0	num_sats	num_tl_120dpd_2m	num_tl_30dpd	num_tl_90g_dpd_24m	num_tl_op_past_12m	pct_tl_nvr_dlq	percent_bc_gt_75	tot_hi_cred_lim	total_bal_ex_mort	total_bc_limit	total_il_high_credit_limit
0	1077501	1296599	5000	5000	4975.0	36 months	10.65%	162.87	B	B2	NaN	10+ years	RENT	24000.0	Verified	Dec-11	Fully Paid	n	https://lendingclub.com/browse/loanDetail.action?loan_id=1077501	Borrower added on 12/22/11 > I need to upgrade my business technologies.<br>	credit_card	Computer	860xx	AZ	27.65	Jan-85	1	NaN	NaN	3	13648	83.70%	9	f	0.00	0.00	5863.155187	5833.84	5000.00	863.16	0.00	0.00	0.00	Jan-15	171.62	NaN	May-16	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
1	1077430	1314167	2500	2500	2500.0	60 months	15.27%	59.83	C	C4	Ryder	< 1 year	RENT	30000.0	Source Verified	Dec-11	Charged Off	n	https://lendingclub.com/browse/loanDetail.action?loan_id=1077430	Borrower added on 12/22/11 > I plan to use this money to finance the motorcycle i am looking at. I plan to have it paid off as soon as possible/when i sell my old bike. I only need this money because the deal im looking at is to good to pass up.<br><br> Borrower added on 12/22/11 > I plan to use this money to finance the motorcycle i am looking at. I plan to have it paid off as soon as possible/when i sell my old bike.I only need this money because the deal im looking at is to good to pass up. I have finished college with an associates degree in business and its takingmeplaces<br>	car	bike	309xx	GA	1.00	Apr-99	5	NaN	NaN	3	1687	9.40%	4	f	0.00	0.00	1008.710000	1008.71	456.46	435.17	0.00	117.08	1.11	Apr-13	119.66	NaN	Sep-13	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
2	1077175	1313524	2400	2400	2400.0	36 months	15.96%	84.33	C	C5	NaN	10+ years	RENT	12252.0	Not Verified	Dec-11	Fully Paid	n	https://lendingclub.com/browse/loanDetail.action?loan_id=1077175	NaN	small_business	real estate business	606xx	IL	8.72	Nov-01	2	NaN	NaN	2	2956	98.50%	10	f	0.00	0.00	3005.666844	3005.67	2400.00	605.67	0.00	0.00	0.00	Jun-14	649.91	NaN	May-16	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
3	1076863	1277178	10000	10000	10000.0	36 months	13.49%	339.31	C	C1	AIR RESOURCES BOARD	10+ years	RENT	49200.0	Source Verified	Dec-11	Fully Paid	n	https://lendingclub.com/browse/loanDetail.action?loan_id=1076863	Borrower added on 12/21/11 > to pay for property tax (borrow from friend, need to pay back) & central A/C need to be replace. I'm very sorry to let my loan expired last time.<br>	other	personel	917xx	CA	20.00	Feb-96	1	35.0	NaN	10	5598	21%	37	f	0.00	0.00	12231.890000	12231.89	10000.00	2214.92	16.97	0.00	0.00	Jan-15	357.48	NaN	Apr-16	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
4	1075358	1311748	3000	3000	3000.0	60 months	12.69%	67.79	B	B5	University Medical Group	1 year	RENT	80000.0	Source Verified	Dec-11	Current	n	https://lendingclub.com/browse/loanDetail.action?loan_id=1075358	Borrower added on 12/21/11 > I plan on combining three large interest bills together and freeing up some extra each month to pay toward other bills. I've always been a good payor but have found myself needing to make adjustments to my budget due to a medical scare. My job is very stable, I love it.<br>	other	Personal	972xx	OR	17.94	Jan-96	0	38.0	NaN	15	27783	53.90%	38	f	524.06	524.06	3513.330000	3513.33	2475.94	1037.39	0.00	0.00	0.00	May-16	67.79	Jun-16	May-16	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
5	1075269	1311441	5000	5000	5000.0	36 months	7.90%	156.46	A	A4	Veolia Transportaton	3 years	RENT	36000.0	Source Verified	Dec-11	Fully Paid	n	https://lendingclub.com/browse/loanDetail.action?loan_id=1075269	NaN	wedding	My wedding loan I promise to pay back	852xx	AZ	11.20	Nov-04	3	NaN	NaN	9	7963	28.30%	12	f	0.00	0.00	5632.210000	5632.21	5000.00	632.21	0.00	0.00	0.00	Jan-15	161.03	NaN	Jan-16	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
6	1069639	1304742	7000	7000	7000.0	60 months	15.96%	170.08	C	C5	Southern Star Photography	8 years	RENT	47004.0	Not Verified	Dec-11	Fully Paid	n	https://lendingclub.com/browse/loanDetail.action?loan_id=1069639	Borrower added on 12/18/11 > I am planning on using the funds to pay off two retail credit cards with 24.99% interest rates, as well as a major bank credit card with a 18.99% rate. I pay all my bills on time, looking for a lower combined payment and lower monthly payment.<br>	debt_consolidation	Loan	280xx	NC	23.51	Jul-05	1	NaN	NaN	7	17726	85.60%	11	f	0.00	0.00	10110.840000	10110.84	6985.61	3125.23	0.00	0.00	0.00	May-16	1313.76	NaN	May-16	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
7	1072053	1288686	3000	3000	3000.0	36 months	18.64%	109.43	E	E1	MKC Accounting	9 years	RENT	48000.0	Source Verified	Dec-11	Fully Paid	n	https://lendingclub.com/browse/loanDetail.action?loan_id=1072053	Borrower added on 12/16/11 > Downpayment for a car.<br>	car	Car Downpayment	900xx	CA	5.35	Jan-07	2	NaN	NaN	4	8221	87.50%	4	f	0.00	0.00	3939.135294	3939.14	3000.00	939.14	0.00	0.00	0.00	Jan-15	111.34	NaN	Dec-14	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
8	1071795	1306957	5600	5600	5600.0	60 months	21.28%	152.39	F	F2	NaN	4 years	OWN	40000.0	Source Verified	Dec-11	Charged Off	n	https://lendingclub.com/browse/loanDetail.action?loan_id=1071795	Borrower added on 12/21/11 > I own a small home-based judgment collection business. I have 5 years experience collecting debts. I am now going from a home office to a small office. I also plan to buy a small debt portfolio (eg. $10K for $1M of debt) <br>My score is not A+ because I own my home and have no mortgage.<br>	small_business	Expand Business & Buy Debt Portfolio	958xx	CA	5.55	Apr-04	2	NaN	NaN	11	5210	32.60%	13	f	0.00	0.00	646.020000	646.02	162.02	294.94	0.00	189.06	2.09	Apr-12	152.39	NaN	Aug-12	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
9	1071570	1306721	5375	5375	5350.0	60 months	12.69%	121.45	B	B5	Starbucks	< 1 year	RENT	15000.0	Verified	Dec-11	Charged Off	n	https://lendingclub.com/browse/loanDetail.action?loan_id=1071570	Borrower added on 12/16/11 > I'm trying to build up my credit history. I live with my brother and have no car payment or credit cards. I am in community college and work full time. Im going to use the money to make some repairs around the house and get some maintenance done on my car.<br><br> Borrower added on 12/20/11 > $1000 down only $4375 to go. Thanks to everyone that invested so far, looking forward to surprising my brother with the fixes around the house.<br>	other	Building my credit history.	774xx	TX	18.08	Sep-04	0	NaN	NaN	2	9279	36.50%	3	f	0.00	0.00	1476.190000	1469.34	673.48	533.42	0.00	269.29	2.52	Nov-12	121.45	NaN	Mar-13	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN

	id	member_id	loan_amnt	funded_amnt	funded_amnt_inv	term	int_rate	installment	grade	sub_grade	emp_title	emp_length	home_ownership	annual_inc	verification_status	issue_d	loan_status	pymnt_plan	url	desc	purpose	title	zip_code	addr_state	dti	delinq_2yrs	earliest_cr_line	inq_last_6mths	mths_since_last_delinq	mths_since_last_record	open_acc	pub_rec	revol_bal	revol_util	total_acc	initial_list_status	total_pymnt	total_pymnt_inv	total_rec_prncp	total_rec_int	last_pymnt_d	last_pymnt_amnt	next_pymnt_d	last_credit_pull_d	collections_12_mths_ex_med	mths_since_last_major_derog	policy_code	application_type	annual_inc_joint	dti_joint	verification_status_joint	tot_coll_amt	tot_cur_bal	open_acc_6m	open_il_6m	open_il_12m	open_il_24m	mths_since_rcnt_il	total_bal_il	il_util	open_rv_12m	open_rv_24m	max_bal_bc	all_util	total_rev_hi_lim	inq_fi	total_cu_tl	inq_last_12m	acc_open_past_24mths	avg_cur_bal	bc_open_to_buy	bc_util	chargeoff_within_12_mths	mo_sin_old_il_acct	mo_sin_old_rev_tl_op	mo_sin_rcnt_rev_tl_op	mo_sin_rcnt_tl	mort_acc	mths_since_recent_bc	mths_since_recent_bc_dlq	mths_since_recent_inq	mths_since_recent_revol_delinq	num_accts_ever_120_pd	num_actv_bc_tl	num_actv_rev_tl	num_bc_sats	num_bc_tl	num_il_tl	num_op_rev_tl	num_rev_accts	num_rev_tl_bal_gt_0	num_sats	num_tl_120dpd_2m	num_tl_30dpd	num_tl_90g_dpd_24m	num_tl_op_past_12m	pct_tl_nvr_dlq	percent_bc_gt_75	pub_rec_bankruptcies	tax_liens	tot_hi_cred_lim	total_bal_ex_mort	total_bc_limit	total_il_high_credit_limit
39707	92666	92661	5000	5000	525.0	36 months	9.33%	159.77	B	B3	Stark and Roth Inc	2 years	MORTGAGE	180000.0	Not Verified	Jul-07	Fully Paid	n	https://lendingclub.com/browse/loanDetail.action?loan_id=92666	Need a loan to make some home improvments	home_improvement	home improvment loan	530xx	WI	11.93	0	Feb-95	1	0.0	0.0	16	0	60568	39.20%	38	f	5751.530533	603.91	5000.0	751.53	Jul-10	161.55	NaN	Jun-07	NaN	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
39708	92552	92542	5000	5000	375.0	36 months	9.96%	161.25	B	B5	Millenium Group	4 years	MORTGAGE	48000.0	Not Verified	Jul-07	Fully Paid	n	https://lendingclub.com/browse/loanDetail.action?loan_id=92552	I would like to pay off my high-interest credit card debts and have a single payment to make every month	debt_consolidation	Tito5000	333xx	FL	8.03	0	Aug-95	1	0.0	0.0	6	0	28329	48.60%	6	f	5804.732505	435.36	5000.0	804.73	Jul-10	162.07	NaN	Jun-10	NaN	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
39709	92533	92529	5000	5000	675.0	36 months	11.22%	164.23	C	C4	Self-Employeed	< 1 year	OWN	80000.0	Not Verified	Jul-07	Fully Paid	n	https://lendingclub.com/browse/loanDetail.action?loan_id=92533	NaN	credit_card	P's Family Credit Loan	537xx	WI	1.21	0	Jul-96	3	0.0	44.0	15	1	27185	16.10%	29	f	5912.052998	798.13	5000.0	912.05	Jul-10	165.17	NaN	Jun-07	NaN	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
39710	92507	92502	5000	5000	250.0	36 months	7.43%	155.38	A	A2	Rush Univ Med Grp	1 year	OWN	85000.0	Not Verified	Jul-07	Fully Paid	n	https://lendingclub.com/browse/loanDetail.action?loan_id=92507	NaN	credit_card	My Credit Card Loan	537xx	WI	0.31	0	Oct-97	0	0.0	0.0	7	0	216	0.60%	19	f	5593.626092	279.68	5000.0	593.63	Jul-10	156.29	NaN	Jun-07	NaN	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
39711	92402	92390	5000	5000	700.0	36 months	8.70%	158.30	B	B1	A. F. Wolfers, Inc.	5 years	MORTGAGE	75000.0	Not Verified	Jul-07	Fully Paid	n	https://lendingclub.com/browse/loanDetail.action?loan_id=92402	I'd like to shift some credit card debt so it has a lower interest rate.	credit_card	Reduce Credit Card Debt	804xx	CO	15.55	0	May-94	0	0.0	0.0	10	0	66033	23%	29	f	5698.603286	797.80	5000.0	698.60	Jul-10	159.83	NaN	Nov-14	NaN	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
39712	92187	92174	2500	2500	1075.0	36 months	8.07%	78.42	A	A4	FiSite Research	4 years	MORTGAGE	110000.0	Not Verified	Jul-07	Fully Paid	n	https://lendingclub.com/browse/loanDetail.action?loan_id=92187	Our current gutter system on our home is old and in need of repair. We will be using the borrowed funds to replace the gutter system on our home.	home_improvement	Home Improvement	802xx	CO	11.33	0	Nov-90	0	0.0	0.0	13	0	7274	13.10%	40	f	2822.969293	1213.88	2500.0	322.97	Jul-10	80.90	NaN	Jun-10	NaN	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
39713	90665	90607	8500	8500	875.0	36 months	10.28%	275.38	C	C1	Squarewave Solutions, Ltd.	3 years	RENT	18000.0	Not Verified	Jul-07	Fully Paid	n	https://lendingclub.com/browse/loanDetail.action?loan_id=90665	The rate of interest and fees incurred by carrying a balance on my credit card are so outrageous at this point that continuing to pay them is patently bad financial thinking. I wish to redirect my efforts at retiring my debt via another more-reasonable means. I have sufficient funds to direct to this end on a monthly basis, and have simply gotten tired of their being gobbled up by interest and fees.	credit_card	Retiring credit card debt	274xx	NC	6.40	1	Dec-86	1	5.0	0.0	6	0	8847	26.90%	9	f	9913.491822	1020.51	8500.0	1413.49	Jul-10	281.94	NaN	Jul-10	NaN	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
39714	90395	90390	5000	5000	1325.0	36 months	8.07%	156.84	A	A4	NaN	< 1 year	MORTGAGE	100000.0	Not Verified	Jul-07	Fully Paid	n	https://lendingclub.com/browse/loanDetail.action?loan_id=90395	NaN	debt_consolidation	MBA Loan Consolidation	017xx	MA	2.30	0	Oct-98	0	0.0	0.0	11	0	9698	19.40%	20	f	5272.161128	1397.12	5000.0	272.16	Apr-08	0.00	NaN	Jun-07	NaN	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
39715	90376	89243	5000	5000	650.0	36 months	7.43%	155.38	A	A2	NaN	< 1 year	MORTGAGE	200000.0	Not Verified	Jul-07	Fully Paid	n	https://lendingclub.com/browse/loanDetail.action?loan_id=90376	NaN	other	JAL Loan	208xx	MD	3.72	0	Nov-88	0	0.0	0.0	17	0	85607	0.70%	26	f	5174.198551	672.66	5000.0	174.20	Jan-08	0.00	NaN	Jun-07	NaN	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
39716	87023	86999	7500	7500	800.0	36 months	13.75%	255.43	E	E2	Evergreen Center	< 1 year	OWN	22000.0	Not Verified	Jun-07	Fully Paid	n	https://lendingclub.com/browse/loanDetail.action?loan_id=87023	I plan to consolidate over $7,000 of debt: a combination of credit cards and student loans.	debt_consolidation	Consolidation Loan	027xx	MA	14.29	1	Oct-03	0	11.0	0.0	7	0	4175	51.50%	8	f	9195.263334	980.83	7500.0	1695.26	Jun-10	256.59	NaN	Jun-10	NaN	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Decimal Number

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Other Punctuation

Decimal Number

Math Symbol

Open Punctuation

Currency Symbol

Control

Space Separator

Dash Punctuation

Close Punctuation

Modifier Symbol

Other Symbol

Other Number

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block